I found this interesting option under the Sql server 2000 Enterprise manager.
If a DBA wants to execute any system procedure when the Sql Server starts
go to
Enterprise Manager-->Databases-->Master-->StoredProcedures
Right Click any system stored procedure and there is an option below which indicates
Execute whenever Sql Server Starts
and check it
To check whether any procedures are running when sql server starts execute the following
USE master
GO
SELECT
name
FROM
sysobjects
WHERE
OBJECTPROPERTY(id, 'ExecIsStartup') = 1
or
USE master
GO
SELECT
ROUTINE_NAME
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
OBJECTPROPERTY(OBJECT_ID(ROUTINE_NAME), 'ExecIsStartUp') = 1
No comments:
Post a Comment