Tim Mitchell


Everyone,

Is there a reference to describe the relevance of the Category column in the sysobjects table I'm trying to track down stored procedures that are set to automatically run at startup and the only thing I can find that is consistent about those that are set to autorun is that they have a value of 16 in the Category column. Is this consistent What else may I glean from this column

Thanks

Tim




Re: Category column in sysobjects

Madhu K Nair


this will give u the sps which run at startup

Run this in Master db.


SELECT * FROM sysobjects WHERE xtype IN ('X','P') AND ObjectProperty(id, 'ExecIsStartup') = 1

Madhu







Re: Category column in sysobjects

Tim Mitchell

Thanks, that is exactly what I needed.

I'm still curious, though, what the category column in this table represents.