Friday, March 9, 2012

List of SQL Server 7.0/2000 instances running

How to get the list of instance of SQL Server 7.0/2000 running on the local machine inside my domain...
I need to prepare the list of all sql instances.. pls help if possible to find details using sql query.I'd start with:EXECUTE master.dbo.xp_cmdshell 'osql -L'You might have to refine it a bit, but it is a place to start.

-PatP

No comments:

Post a Comment