How to know if there is SQL 2000 installed?

Question

Post reply

How to know if there is SQL 2000 installed?

SQL ORACLE

One Orange Chip

Points: 27807
More actions
March 10, 2010 at 5:20 pm

#137595

We are cleaning SQL Servers and would like to clean up the SQL 2000 installation, including server and client tools components.
How to check whether or not these component installed using script(s)?
Many thanks in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 1

Try SQL Ping...

http://searchsqlserver.techtarget.com/downloadPage/0,295339,sid87_gci1135136,00.html

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 2

I do not want to any other tools to be installed. I would like to get the info using script(s).

Thanks.

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 3

VBscript

http://blog.netnerds.net/2007/01/vbscript-enumerating-all-sql-servers-on-a-domain/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

SQL Ping would not need to be installed on any server. It would be installed on a desktop and search the network for instances of SQL Server (all versions).

You could also try to use isql or osql. Those would be able to find broadcasting sql servers (and come with sql server, thus no install necessary).

Here are some references:

http://www.sqlteam.com/article/finding-sql-servers-running-on-a-network

http://www.databasejournal.com/features/mssql/article.php/3397981/Scanning-the-network-for-SQL-Server.htm

http://sqlserver2000.databases.aspfaq.com/how-do-i-find-all-the-available-sql-servers-on-my-network.html

http://www.devasp.net/net/articles/display/683.html

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 5

Just a little note to add if your are going on a mass ramage to remove user tools.

MSDE (2000) and Express (2005/8) are installed as part of some product. I believe office 07 installs express.

Good luck