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 |
|
gavakie
Posting Yak Master
221 Posts |
 Posted - 2007-10-01 : 09:44:53
|
| Im a little lost. Someone posted this for me. INFORMATION_SCHEMA.TABLESINFORMATION_SCHEMA.TABLE_CONSTRAINTSINFORMATION_SCHEMA.COLUMNSHow does this help me find what tables are used in my storedprocedures and views. Im not quite sure how the syntax works on it. I cant find an example. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-01 : 10:38:31
|
| it doesn't really...you have to use sp_depends stored procedure_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2007-10-01 : 10:49:14
|
| I have tried that. The problem I am running into is if the Stored Proc has tables it use from a different DB then it wont show those. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 11:31:58
|
Might help to know what problem you are trying to solve, there might be a different starting point  |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-01 : 11:34:17
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90217_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
elaborate for me