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 |
|
DURGESH
Posting Yak Master
105 Posts |
 Posted - 2008-07-03 : 05:48:00
|
| hi all,i have two databases of same objectswhen i am seeing the depends of one of the table in both the databases. Its showing wrong no of dependent objectsexample:i have a table schema in both the database. i wrote a trigger on this table called trg_schema which is using a column value of another table called tbl_nmpairsnow i want to know the dependent objects of tbl_nmpairsIn one database it is showing trg_schema and in another it is not displaying the trg_schema as dependent objectcan anybody help me to solve this issuethanks in advanceregardsjaydee |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-03 : 06:03:22
|
| how are you checking for dependent objects? if u r using sp_depends please note that it will list only those dependencies which are in current db. |
 |
|
|
DURGESH
Posting Yak Master
105 Posts |
Posted - 2008-07-03 : 07:00:16
|
| i have executed sp_depends 'tbl_nmpairs' on both the databases |
|
|
|
|
|
|
can anybody comment on this topic