SQLism

Logging and Blogging SQL Server Experiences.

Thursday, August 16, 2012

Script to find DB_ID in SQL Server 2000

USE master

SELECT NAME
 ,DB_ID(NAME) AS DB_ID
FROM sysdatabases
ORDER BY dbid
Posted by SQLism at 5:26 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: 2000, DB_ID, find, in, Script, Server, SQL, to

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2020 (6)
    • ►  July (1)
    • ►  March (1)
    • ►  February (4)
  • ►  2018 (3)
    • ►  August (3)
  • ►  2017 (10)
    • ►  December (1)
    • ►  October (1)
    • ►  June (1)
    • ►  May (1)
    • ►  February (4)
    • ►  January (2)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
  • ►  2015 (10)
    • ►  September (1)
    • ►  April (9)
  • ►  2014 (53)
    • ►  October (19)
    • ►  September (33)
    • ►  June (1)
  • ►  2013 (12)
    • ►  October (2)
    • ►  September (1)
    • ►  August (5)
    • ►  July (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ▼  2012 (9)
    • ►  September (1)
    • ▼  August (6)
      • Finding the Port Number for a particular SQL Serve...
      • Free ebook: Introducing Microsoft SQL Server 2012
      • SSIS Package in SQL Server Agent Job Fails
      • Script to find DB_ID in SQL Server 2000
      • T-SQL Script to load the trace file to a database ...
      • Script to remove SQL Server database from single-u...
    • ►  July (2)
Simple theme. Theme images by luoman. Powered by Blogger.