PrepAway - Latest Free Exam Questions & Answers

Tag: procedure sys sp_serveroption

Which system stored procedure should you use to configure the MaintenanceTasks_sp stored procedure?

You are responsible for managing an instance of SQL Server 2008. You create a stored procedure named MaintenanceTasks_sp to perform maintenance tasks in the tempdb database. You want to ensure that the MaintenanceTasks_sp stored procedure executes automatically when the SQL Server starts.
Which system stored procedure should you use to configure the MaintenanceTasks_sp stored procedure?