MCITP

MCITP

Tuesday, September 11, 2012

How to find the start scan procedure enabled in SQL 2005/2008


USE MASTER
GO
SELECT VALUE, VALUE_IN_USE, DESCRIPTION
FROM SYS.CONFIGURATIONS
WHERE NAME = 'scan for startup procs'
GO

No comments:

Post a Comment

Followers