"Scan for startup procs" in sp_configure

  • Is there any security risk on enabling SQL Server configuration

    sp_configure 'scan for startup procs',1

    reconfigure

  • As long as you have control of the members of your sysadmin server role there is no security concern because the procedure sp_procoption which is used to set a stored procedure to run at start-up requires a member of sysadmin to execute.

    [font="Courier New"]Michael Connolly
    [/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply