Category column in sysobjects

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

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

|||

Thanks, that is exactly what I needed.

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