Multiple choice technology databases

Which of the following option helps to execute a stored procedure when the server instance starts?

  1. sp_procoption

  2. sp_serverstartup

  3. sp_autoexecute

  4. None of the above

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

sp_procoption is a system stored procedure that configures a stored procedure to execute automatically when SQL Server starts. Only stored procedures in the master database that are owned by dbo can be marked for startup execution. sp_serverstartup and sp_autoexecute are not valid SQL Server system procedures.