Home » Open Source » MySQL » How many MSSQL DBs are present on a server? (Unix or Windows)
How many MSSQL DBs are present on a server? [message #511630] Tue, 14 June 2011 05:47 Go to next message
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
Junior Member

Hi All,

I have got a task to find what all MSSQL DBs are present on a given server.
Can any one help me on this, I heard about the sqlscan.exe which will list all the available sql dbs on any given ip address.
But for me it does not work as it also needs sql server installed on the local machine.
So is there a way to find how many or which mssql dbs are present on any given unix server.

Thanks in advance
Shamsh Pervaiz
Re: How many MSSQL DBs are present on a server? [message #511645 is a reply to message #511630] Tue, 14 June 2011 06:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>find how many or which mssql dbs are present on any given unix server.

Microsoft SQL server in Unix?
Is this a trick question?

Re: How many MSSQL DBs are present on a server? [message #511648 is a reply to message #511645] Tue, 14 June 2011 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition why posting a MSSQL question in a MySQL forum?

Regards
Michel
Re: How many MSSQL DBs are present on a server? [message #511649 is a reply to message #511648] Tue, 14 June 2011 06:36 Go to previous messageGo to next message
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
Junior Member

Sorry for that.. But I have task to find both Mssql and Mysql DBs.
So was more concerned about the MSSQL DBs and posted here..
"Microsoft SQL server in Unix?
Is this a trick question?"
Not sure what it is.. I 'm working for MSSQL/MYSQL for the first time.. No idea how the server is installed and how to check.

Hence require help on this..
Re: How many MSSQL DBs are present on a server? [message #511651 is a reply to message #511649] Tue, 14 June 2011 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post mySQL question here and MSSQL question in MSSQL forum.
We can't help on the later one.
Topic is locked.

Regards
Michel
Re: How many MSSQL DBs are present on a server? [message #511655 is a reply to message #511651] Tue, 14 June 2011 07:01 Go to previous messageGo to next message
Littlefoot
Messages: 19350
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OP
I 'm working for MSSQL/MYSQL for the first time


I reopened the topic (so that people could assist about MySQL part of the question).

[Updated on: Tue, 14 June 2011 07:02]

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511657 is a reply to message #511655] Tue, 14 June 2011 07:13 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no question about MySQL.

Regards
Michel
Re: How many MSSQL DBs are present on a server? [message #511658 is a reply to message #511649] Tue, 14 June 2011 07:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Well, MS SQL will not run in Unix.

For MySQL, it is quite simple.
Just issue
show databases



http://dev.mysql.com/doc/refman/5.1/en/show-databases.html
mahesh@flobee ~$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1061
Server version: 5.0.51a-3ubuntu5.8 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------------------+
| Database             |
+----------------------+
| information_schema   | 
| academic_appointment | 
| hgcentral            | 
| joomla               | 
| mydb                 | 
| mysql                | 
| reddien              | 
| scott                | 
| winenews             | 
+----------------------+
9 rows in set (0.00 sec)

[Updated on: Tue, 14 June 2011 07:16]

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511659 is a reply to message #511658] Tue, 14 June 2011 07:18 Go to previous messageGo to next message
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
Junior Member

Thanks for the inputs for MySQL.
Re: How many MSSQL DBs are present on a server? [message #511921 is a reply to message #511659] Thu, 16 June 2011 02:07 Go to previous messageGo to next message
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
Junior Member

Finally got the solution..
Scansql 1.0 is the tool used to scan for the mssql database. Also one can use sqlpingv3.0 for scanning the mssql databases.

Thanks all.
Re: How many MSSQL DBs are present on a server? [message #511923 is a reply to message #511921] Thu, 16 June 2011 02:36 Go to previous message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: MYSQL Dead lock issues
Next Topic: datatype of BLOB and CLOB on mysql database to oracle database (merged)
Goto Forum:
  


Current Time: Sat Aug 02 03:49:39 CDT 2014

Total time taken to generate the page: 0.08786 seconds