In the following lesson, you can learn how to get All the Information in the Database using sys.databases.

In SQL Database, this view is available in the master database and user databases. In the master database, this view returns the information on the master database and all user databases on the server. In a user database, this view returns information only on the current database and the master database.

Use the sys. databases view in the master database of the SQL Database server where the new database is being created. After the database copy starts, you can query the sys.databases and the sys.dm_database_copies views from the master database of the destination server to retrieve more information about the copying progress.

Database Related Information from sys.databases

The article was published on February 22, 2017 @ 10:18 AM

Leave a Comment

1 Comment