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 |
|
ilya_frey
Starting Member
2 Posts |
 Posted - 2009-01-26 : 16:21:48
|
| VIEW_TABLE_USAGE show only tables that belong to current database. Is there simple way to get ALL tables of the view in case if some of them belong to another databases? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-27 : 00:43:30
|
| if you're using sql 2008, see thishttp://www.builderau.com.au/program/sqlserver/soa/Using-Object-Dependencies-in-SQL-Server-2008/0,339028455,339292935,00.htm |
 |
|
|
ilya_frey
Starting Member
2 Posts |
Posted - 2009-01-27 : 10:14:22
|
quote:
Originally posted by visakh16
if you're using sql 2008, see thishttp://www.builderau.com.au/program/sqlserver/soa/Using-Object-Dependencies-in-SQL-Server-2008/0,339028455,339292935,00.htm
Thank you! But unfortunately I am using sql 2005 ... |
|
|
|
|
|
|
tables in a view