Run from Query Analyzer:
USE master
SELECT name, DB_ID(name) AS DB_ID
FROM sysdatabases
ORDER BY name
Content retrieved from: https://support.appliedi.net/kb/a303/howto-obtain-sql-database-id.aspx.
Run from Query Analyzer:
USE master
SELECT name, DB_ID(name) AS DB_ID
FROM sysdatabases
ORDER BY name
Content retrieved from: https://support.appliedi.net/kb/a303/howto-obtain-sql-database-id.aspx.