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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-06-24 : 02:39:47
|
| In sqlserver 2008i have created 100 stored procedures,now i want to spilit the storedprocedures into different name/folderto identify some 30 sp's are belong tp some module and some 30 sp's are belong to some module like thatcan i able to differentiate that in sqlserver 2008?eventhough sp's name itself tells which module it is |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-06-24 : 02:57:08
|
| rename the SP with a prefix and make it as a group.just look the o/p of the querySelect 'sp_rename '+''''+name+''''+',''prefix_'+name+'''' from sys.objects where type='p'and name like '%conditions%'Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
|
|
|
stored procedures