Thanks Roman.
While I was creating my own stored proc (using the Enterprise Manager instead creating the CREATE PROCEDURE manually - I am such a lazy guy!!!), I discovered a check box at the bottom of Stored Proc editor: "Execute whenever SQL Server starts ". I have used it, and generated the script for my SP and discovered that lines are added to the CREATE to call sp_procoption.
Thanks again Roman.
>I almost pointed you to that article yesterday but it said that the issue applies to Visual Studio versions earlier than Visual Studio.NET so I didn't think it would help.
>
>At least I can help with automation. You can create a stored procedure to call sp_sdidebug and mark it for automatic execution. Then the stored procedure will be executed whenever SQL Server starts. You have to use T-SQL, EM doesn't let you set that option:
>
>EXEC sp_procoption 'MyProc', 'startup', 'true'
>
>To check whether a stored procedure is marked for startup execution, you can run this code:
>
>SELECT OBJECTPROPERTY (object_id('MyProc'), 'ExecIsStartup')
>
>Roman
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com