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