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 |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-06-23 : 08:19:48
|
| Hi Gurus,I have partiular stored procedure.Now i want to know as this PROC belongs to which DATABASE.On a server we may be having several databases from those how can we know as this PROC belongs to particular database.Is there ay systable for this..?Thanks,ServerTeam |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-23 : 08:23:46
|
| select * from sysobjects where name='YourProcName' AND type='p' |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-23 : 08:30:06
|
| and use sp_Msforeachdb if you want to check this on all dbs of a server. |
|
|
|
|
|
|
Stored PROC is in which database