Current location: Hot Scripts Forums » Programming Languages » Windows .NET Programming » To list all available databases on a given server


To list all available databases on a given server

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-03-05, 04:28 AM
priyank priyank is offline
New Member
  
Join Date: Nov 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
To list all available databases on a given server
To list all available databases on a given server is there have any system stored procedure in sql 2000 or any code in vb.net
Reply With Quote
  #2 (permalink)  
Old 12-02-05, 02:26 PM
digioz's Avatar
digioz digioz is offline
Community VIP
  
Join Date: Oct 2003
Location: Chicago, IL
Posts: 2,171
Thanks: 3
Thanked 9 Times in 9 Posts
The SQL syntax for listing ALL databases on a Microsoft SQL Server is:

Code:
SELECT catalog_name FROM information_schema.schemata
__________________
Reply With Quote
Reply

Bookmarks

« New in this forum! | run a script file in the real time »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Free web site, control panel, and dedicated IP with game server purchase for only $25 twastudios General Advertisements 3 10-20-05 06:13 AM
List files from another server kailexx PHP 1 08-27-05 01:37 PM
How do i Connect to other Databases (like Access, SQL Server) using PHP? EvilDeveloper PHP 3 02-22-05 07:28 AM
Browse through list of databases on server RFickling Windows .NET Programming 0 11-11-04 09:07 AM
help finding a mail list server mikestreb PHP 0 09-16-03 11:35 PM


All times are GMT -5. The time now is 02:16 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.