Microsoft SQL Server 2008 February CTP (CTP6) - SSMS fails to complete sql query execution or query parsing
I have installed MS SQL Server 2008 (aka Katmai) February CTP, CTP6 recently on my computer.
I realized later that Microsoft SQL Server Management Studio (SSMS) fails to complete sql queries execution or query parsing. Even the query is as simple as "SELECT 1".
I first suspected from existance of two different versions of MS SQL Server. On my computer both MS SQL Server 2005 and MS SQL Server 2008 runs simultaneously or side by side without a problem.
Prior to CTP6, in CTP5 or November CTP, it was not possible to install the Client Tools for SQL2008 without uninstalling the MS SQL2005 Client Tools.
So running side-by-side SSMS (SQL Server Management Studio) in version Microsoft SQL Server 2005 and Microsoft SQL Server 2008 was a little bit confusing for me. Btw still it is.
I get astonished that the SSMS was not the reason of this problem or bug which causes the SQL 2008 query editor to hang while running queries or executing query batches.
The only response from the sql editor is the following notes on the status bar.
Parsing query batch...
Executing query...
Below I have copied down the informations about SSMS :
Microsoft SQL Server Management Studio (expires in 173 days) 10.0.1300.13 ((SQL_PreRelease).080207-2350 )
Microsoft Analysis Services Client Tools 2007.0100.1300.013 ((SQL_PreRelease).080207-2350 )
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600
I learnt later that if Microsoft SQL Server Compact 3.5 SP1 Beta Management Tools ENU is installed, query execution hang problem occurs and queries run forever.
The parse query and query execution runs forever problem is pointed in Microsoft Connect for SQL Server 2008 Nov CTP and the solution is summarized in steps.
I'm restating here the solution for resolving this issue suggested by Eric Kang, SQL Server Program Manager from Microsoft.
1. Open the Add or Remove Programs. You can also run the shortcut appwiz.cpl on the RUN
2. Uninstall "Microsoft SQL Server Compact 3.5 SP1 Beta Management Tools ENU"
3. Go to the path from where one has installed SQL Server
4. There open the folder <install path>\servers\setup and install sscesqlwbtools package by running sscesqlwbtools.msi
After the completion of the sscesqlwbtools installation, open the SSMS and run any sql script or t-sql statement, you will see that the query will execute successfully without a hang.
And the parse query and query execution run forever problem will be solved.