Tim Mitchell


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



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


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.