Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pjanil1
Starting Member
10 Posts |
 Posted - 2003-07-03 : 06:25:17
|
| Is there a way to see which all are the startup procedures in the server. In 6.5 we had sp_helpstartup. after upgrading to 2000, I find using sp_procoption I can only set or reset 'startup' of a particular procedure. no eqvt of sp_helpstartup available . I feel it should have been there |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-07-03 : 06:42:13
|
| you could always open up sp_helpstartup in 6.5 and rewrite it for SQL2K and then post it here for anyone to use.====Paul |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-03 : 07:17:44
|
| Or look in Books Online:SELECT name FROM sysobjects WHERE OBJECTPROPERTY(id, 'ExecIsStartup')=1Also look at the related functions (COLUMNPROPERTY, INDEXPROPERTY, etc.) |
|
|
|
|
|
|
startup procedure listing