John Darby
asked on
SELECT * FROM sys.databases
In running the query below, does the resulting list of databases mean that each database on a SQL server has a table which lists the other co-located databases? Or, is this query actually getting data external to the database itself?
SELECT * FROM sys.databases
Thank you!
JohnD
SELECT * FROM sys.databases
Thank you!
JohnD
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, each! I am feeling a bit dense here...WHERE is the (meta)data stored? In the MASTER DB?
ASKER
lcohan, I se your answer, and from whence you quoted the line, but it seems odd that each SQL Server DB would have one row of system data inscribed into each?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the splendid education! :)
http://msdn.microsoft.com/en-us/library/ms178534(v=sql.100).aspx