Home About Us SQL Interview Book Contact Us RSS
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
Articles
Code Snippets
Links
FAQ
Resources

Saravana Kumar
Vinod Kumar


How to find the scripts set at Startup?

This is something a normal DBA would like to know. What are the start-up scripts that have been configured on my Server. Interestingly this is a simple query as below:

SELECT name

FROM master..sysobjects

WHERE type = 'p'

AND OBJECTPROPERTY(id, 'ExecIsStartup') = 1