EXEC sp_procoption N'[dbo].[MyCreatePermissions]', 'startup', '1'Note: For disable it use 'startup', '0'.
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Showing posts with label sql server - sp_procoption. Show all posts
Showing posts with label sql server - sp_procoption. Show all posts
Thursday, February 1, 2018
SQL SERVER - How call stored procedure automatically when SQL server instance started
This code call stored proc dbo.MyCreatePermissions after SQL server instance start:
Subscribe to:
Posts (Atom)