RIL_button( “http://sqlconcept.com/2011/06/24/audit-startup-procedures-in-sql-server/”, “Audit startup procedures in SQL Server” );
Here is a script which will list all enabled or disabled startup procedures in SQL Server.
?View Code TSQLuse [master]
SET NOCOUNT ON
SET QUOTED_IDENTIFIER ON
DECLARE @procedureID INT
CREATE TABLE #procedureList(objectname varchar(100),startup_status varchar(50))
DECLARE procedure_cursor CURSOR FOR SELECT id
FROM master.dbo.sysobjects WHERE TYPE IN (’P',’X')
OPEN procedure_cursor
FETCH NEXT FROM procedure_cursor INTO @procedureID
WHILE @@FETCH_STATUS =
Continue reading [...] Audit startup procedures in SQL Server [...]
Loading ...
(8 votes, average: 4.88 out of 5)
