Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

what will be sql-Query to find all database name in a sql-server-2000

Posted Date: 12 Jan 2007 Total Responses: 4

Posted By: kanan Member Level: Bronze Points: 2

hi to all!
i want to know all database name in a server , plz give be the sql-Query to find all database name in a sql-server-2000
thank in advance

Responses

Member Level: Gold

Rating:

Points: 2

sp_databases

Author: Rajaraman 12 Jan 2007

Member Level: Diamond

Rating:

Points: 2

Yes.. ravi pointed out correct stored procedure..

1. use Sp_Database
2. Select name from SysDatabase

Author: Sriman N Vangala 12 Jan 2007

Member Level: Diamond

Rating:

Points: 2

exec sp_databases or select name from master..sysdatabases

Post Reply

You must Sign In to post a response.

	Next : Generate columns dynamically
	Previous : sever name in networking
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers BizTalk Adaptors Web Design

doors in nj