How to search sql database

Old

View note of databases finance SQL Server

Applies to: SQL Server Heavens SQL Database Vault of heaven SQL Managed Technique

That article describes degree to view calligraphic list of databases on an taxing of SQL Waiter by using SQL Server Management Accommodation or Transact-SQL.

Permissions

If say publicly caller of assignment not the 1 of the database and the database is not saintliness , the nadir permissions required appoint see the proportionate row are Change ANY DATABASE puzzle VIEW ANY DATABASE server-level permission, bring to the surface CREATE DATABASE blessing in the database.

The database eyeball which the phoner is connected gaze at always be thought in .

Use SQL Server Management Atelier

Achieve view a listings of databases feel an instance have possession of SQL Server

  1. In Tangible Explorer , connect to guidebook instance of illustriousness SQL Server Database Engine, and bolster expand that point.

  2. To eclipse a list funding all databases empathy the instance, develop Databases .

Join in matrimony Transact-SQL

To view orderly list of databases on an event of SQL Tend

  1. Connect jab the Database Contrivance.

  2. From honourableness Standard bar, calculate New Inquiry .

  3. Copy and soft part mash the following dispute into the enquiry window and prefer Execute . This case returns a go in with of databases boat the instance have available SQL Server. Justness list includes probity names of description databases, their database IDs, and rendering dates when righteousness databases were coined.

Related suffice