vajarov (va*****@gmail.com) writes:
I am pretty happy with the new system views in SQL 2005 but there is
one thing I could not figure out: What is the view that let you see
what object belongs to what DB? Sorry for the simple question, Cheers,
I'm not really sure that I understand it. Objects are either server-bound
or database-bound. And if it's database-bound, the object is referred to
by db.schema.name. If you have a single-part name like 'mytable', then
that object belongs to the current database. (There are some exceptions
when it comes to the system views itself, but let's ignore that.)
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx