July 23, 2007 at 3:08 pm
I need to check for startup procedures on a few SQL 2000 servers, and I can't find reference on how to do it. I know I can do it on 2005 with the following:
select name from sys.procedures where is_auto_executed=0
Is there any similar method to do in SQL 2000? I looked at the sysobjects table where type = 'p' and don't see a designation for what would be startup or not.
Any help would be appreciated.
Thanks.
Jon
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 23, 2007 at 3:19 pm
I think this should work in both 2000 and 2005.
select
name, objectproperty(id, 'ExecIsStartup')
from
sysobjects
where
objectproperty(id, 'ExecIsStartup') = 1
Regards,
Rubes
July 24, 2007 at 6:15 am
Just include xtype='P' alone so that you can limit the search in the system table.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 24, 2007 at 7:17 am
Thank you for the information. It worked perfectly.
Jon
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy