Written by:R Teachout
1/18/2008 12:41 PM

SELECT dbid FROM master.dbo.sysdatabases WHERE name = 'database_name'

Or if you only have the ID:

SELECT name FROM master.dbo.sysdatabases WHERE dbid = ###

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel