Adam Angelini
SSCrazy Eights
Points: 8548
More actions
February 1, 2007 at 2:39 pm
#62344
Does anyone know how to search for procedures that have been marked to autostart using sp_procoption?
Ninja's_RGR'us
SSC Guru
Points: 294069
February 1, 2007 at 2:55 pm
#687236
SELECT Name FROM dbo.SysObjects WHERE OBJECTPROPERTY(id, 'ExecIsStartup') = 1
February 1, 2007 at 3:00 pm
#687237
That did the trick, Thanks!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply