Multiple Server Query Execution in SQL Server 2008

SQL Server 2008 SSMS introduces a new feature, Multiple Server Query Execution, in Query Editor. This feature intends to increase the productivity of running same query against multiple servers at once. Some of useage include: ·         Configure group of servers or server farm ·         Generate report or document from multiple servers ·         Analyze result from multiple servers ·         or Run…

9

November CTP News: Workaround fix for query execution issue

SQL Server 2008 November CTP (CTP5) has a known issue that any query execution hangs indefinitely. Fortunately, there is a quick and simple workaround to fix the issue. Cause & Problem: User changes the default setup directory to a custom one during the initial setup. Query Editor hangs indefinitely when user execute any query, even a simple…

2