Categories
DBA

Running Adhoc queries against multiple servers using SSMS 2008

Getting information from multi servers for a query is a big process for DBAs and we don’t have a direct option available till SQL 2008 Client tools. We need to write our own manual batch file to execute the query against all the server to fetch the information. In SQL Server 2008 management studio MS team has introduced this in SQL Server management studio 2008.