OraFAQ Forum: MySQL » How many MSSQL DBs are present on a server?

Home » Open Source » MySQL » How many MSSQL DBs are present on a server? (Unix or Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How many MSSQL DBs are present on a server? [message #511630]

Tue, 14 June 2011 05:47

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

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511645 is a reply to message #511630]

Tue, 14 June 2011 06:23

Mahesh Rajendran
Messages: 10708
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?

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511648 is a reply to message #511645]

Tue, 14 June 2011 06:33

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In addition why posting a MSSQL question in a MySQL forum?

Regards
Michel

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511649 is a reply to message #511648]

Tue, 14 June 2011 06:36

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..

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511651 is a reply to message #511649]

Tue, 14 June 2011 06:39

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511655 is a reply to message #511651]

Tue, 14 June 2011 07:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no question about MySQL.

Regards
Michel

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511658 is a reply to message #511649]

Tue, 14 June 2011 07:15

Mahesh Rajendran
Messages: 10708
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

shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore

Junior Member

Thanks for the inputs for MySQL.

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511921 is a reply to message #511659]

Thu, 16 June 2011 02:07

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.

Report message to a moderator

Re: How many MSSQL DBs are present on a server? [message #511923 is a reply to message #511921]

Thu, 16 June 2011 02:36

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 20:12:30 CST 2025