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 |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-05-31 : 08:52:26
|
| hi all,by executing which statement i can find all system procedureslike sp_send_mailMalathi Rao |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-31 : 09:03:43
|
| [code]select specific_name from master.information_schema.routines order by 1[/code]or if you want to specifically find all extended procs:[code]use mastergoselect object_name(id) from syscomments where object_name(id) like 'xp%' order by 1[/code]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
sql statement