Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Querying Microsoft SQL Server

I am a technology enthusiast and software developer by profession. I am developing .Net/database based enterprise applications from past 3 years.

My skills includes C# ,ASP.NET,SQL Server 2008 and MVC . My areas of interests are database development and application software development using Microsoft Technologies.

Search all running SQL Server instances over LAN


Sometimes you need to know how many and what instances of SQL Server running in your organization over Network. You can easily see in simple steps
  •    Go to SSMS.
  •    Object Explorer
  •    Click on Connect




  •      Go to Server Name Dropdown and Select Browse for More


There are two options Local Servers and Network Servers.

  •           Local Servers: It lists all instances installed on your local machine.
  •       Network Servers: It lists all instances installed on your Network.


There are various utilities with more functionality to achieve the same.
I find some utility as
Quest Discovery Wizard for SQL Server makes it simple to detect all the SQL Server instances in your organization and monitor your network for changes. It even helps you find SQL Server instances that native tools cannot detect.
With Discovery Wizard, you can:
Create an inventory of the databases on your network and the amount of data they contain
Select databases for consolidation
Review database history, including installation and creation dates
Find out which SQL Server versions and service packs are deployed
Learn server, instance, and operating system names
See who your end users are

The Microsoft Assessment and Planning Toolkit make it easy to assess your current IT infrastructure for a variety of technology migration projects. This Solution Accelerator provides a powerful inventory, assessment, and reporting tool to simplify the migration planning process.




Comments

Leave a comment on the original post [queryingsql.blogspot.com, opens in a new window]

Loading comments...