April 17, 2011 at 6:38 pm
When upgrade servers, I see instruction I wiill have to diable all starup stored procedures. Becasue those stored procedures set to excute on startup might bloack the upgrade process.
How can I find out if we have start up stored procedure, I don't think we have, but want to make sure.
Thanks
April 18, 2011 at 2:17 am
If you don't think you have, the easiest way to check is to check the "Scan for Startup Procs" configuration setting. If this is False, then you don't have any.
April 18, 2011 at 7:22 am
Here's a script from Brent Ozar's BLITZ! 60 Minute SQL Server Takeovers presentation.
USE master
GO
SELECT *
FROM master.INFORMATION_SCHEMA.ROUTINES
WHERE OBJECTPROPERTY(OBJECT_ID(ROUTINE_NAME),'ExecIsStartup') = 1
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 18, 2011 at 9:27 am
Thanks, I tried both, it's false.
This is very helpful
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply