Sql server 2005- sp_helpdb
EXEC sp_helpdb;
This will return the information about all the database on the connected server.
EXEC sp_helpdb N’AdventureWorks’;
To get a particular database information, provides database name.
1 Comment »
RSS feed for comments on this post. TrackBack URI
I m happy to read this.