Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Get All Database Names????

3 Posts 3 Posters 0 Views 1 Watching

A Offline
A Offline
astrovirgin

wrote on last edited by

#1

Hi, Is it possible to get all the database names through a query(or any other way)those are present in SQL Server?
M W 2 Replies Last reply

0
A astrovirgin

Hi, Is it possible to get all the database names through a query(or any other way)those are present in SQL Server?
M Offline
M Offline
Mycroft Holmes

wrote on last edited by

#2

Get to know your sys? tables Select DBID ,Name From sysdatabases Order By name

Never underestimate the power of human stupidity RAH
1 Reply Last reply

0
A astrovirgin

Hi, Is it possible to get all the database names through a query(or any other way)those are present in SQL Server?
W Offline
W Offline
Wendelius

wrote on last edited by

#3

Either use sp_helpdb pprocedure or query master..sysdatabases.

The need to optimize rises from a bad design
1 Reply Last reply

0

Log in to reply