I upgraded an instance from v2008 to v2014 over the weekend. Fortunately, everything went well, but this was one of the prerequisites:
- Disable all startup stored procedures, as the upgrade process will stop and start services on the SQL Server instance being upgraded. Stored procedures processed at startup time might block the upgrade process.
So I ask myself -- how do I find all startup procs? Very simple. Run this query to identify what procedures are configured to run at startup:
-- find procs
that run at startup
SELECT
name,create_date,modify_date
FROM sys.procedures
WHERE OBJECTPROPERTY(OBJECT_ID, 'ExecIsStartup') = 1
-- edit to run
at startup, or not
EXEC sp_procoption
@procname
= 'usp_MssqlServiceStart',@optionname= 'startup',@optionvalue = 'off'
I have read your blog and I gathered some needful information from your blog. Keep update your blog. Waiting for your next update. dubai silicon oasis auditors
ReplyDelete