FREE Subscription to Dr. Dobb’s Digest: Same Great Content, New Digital Edition
Site Archive (Complete)
ABOUT US | CONTACT | ADVERTISE | SUBSCRIBE | SOURCE CODE | NEWSLETTERS | RESOURCES | BLOGS | PODCASTS | GO PARALLEL
Database Blog: Programmatically enumerate all SQL Server Databases
DATABASE
EXCEPTION::QUERY

A Blog About Database Products and Technology.

by Kevin Carlson
SELECT * FROM [Musings]

Database matters.

by Niklas Hemdal
June 08, 2006

Programmatically enumerate all SQL Server Databases

From time to time, being able to discover the names of all databases on a SQL server can be very helpful. There are a number of ways to achieve this goal.

Keith Rull offers one way, using the sp_databases system stored procedure, as he describes here.

Posted by Douglas Reilly at 10:51 AM  Permalink



 
INFO-LINK


| All Feeds
© 2009 TechWeb, Privacy Policy, Terms of Service, United Business Media LLC
Comments about the web site: webmaster@ddj.com