SQLism

Logging and Blogging SQL Server Experiences.

Showing posts with label 2000. Show all posts
Showing posts with label 2000. Show all posts

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 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: 2000, DB_ID, find, in, Script, Server, SQL, to
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2020 (6)
    • ▼  July (1)
      • Reorganize all indexes in a Database in SQL Server.
    • ►  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)
    • ►  July (2)
Simple theme. Theme images by luoman. Powered by Blogger.