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 |
|
AKP2008
Starting Member
45 Posts |
 Posted - 2009-02-18 : 01:53:58
|
| Hi All,Is there any way to find the procedures which are using tables not exists in a database.Please help.Thanks in Advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-18 : 01:55:45
|
| you mean procedures using other db tables? |
 |
|
|
AKP2008
Starting Member
45 Posts |
Posted - 2009-02-18 : 02:01:12
|
quote:
Originally posted by visakh16
you mean procedures using other db tables?
NoActually my requirement is i have created database from another existing database and deleted some tables from new database. But i forgot to delete procedures related to those tables. Now i want to delete those procedures. How can i find them. |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-02-18 : 02:05:10
|
| try thisselect object_name(id) from sys.syscomments where text like '%tablename%' |
|
|
|
AKP2008
Starting Member
45 Posts |
Posted - 2009-02-18 : 02:13:12
|
| But I don't know the table names then how can i find. |
|
|
|
|
|
|
Finding Procedures