SQL Server Home
SQL Server Management Studio (SSMS) 2008 and 2005 Compatibility Issue
2/4/2009 9:30:50 AM
Primary Feedback Item:
User(s) can reproduce this bug
Here is the configuration of my machine:
Windows XP SP2
SQL Server 2005 Developer SP3
SQL Server 2008 Developer
Visual Studio 2005 SP1
Visual Studio 2008 SP1
I have already looked at this: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=298975
and this: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=361706
I also discuss the issue here: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/01bc4e07-0de5-466e-9a29-8d3d4bc0de8f
Here is a breakdown of the issue:
When creating a new solution from within SSMS 2008, the project gets created (I specify a new solution name in order to create a "parent" solution node which will contain multiple children project nodes), but nothing shows up in the Solution Explorer. The Solution Explorer stays blank once I click "OK" on the "Create New Project" dialog box. When I browse to the directory where the solution and the project is to be created, there is no solution file, but the project file exists. It seems SSMS 2008 loses track of what's going on.
Then, when I double click the project file, it opens up in SSMS 2005!? I guess I was expecting it to open in SSMS 2008.
In any case, I have tried repairing the tools as suggested here, even though I do not receive the error messages discussed on the same Webpage: http://www.sqlcoffee.com/Troubleshooting010.htm
Hopefully, this will get addressed - it's a big issue for creating new solutions that are supposed to be deployed in SQL Server 2008 and that need to be synchronized in Source Safe.
SQL Server 2008 - Developer Edition
Tools (SSMS, Agent, Profiler, etc.)
Windows XP SP2 Professional
Operating System Language
Steps to Reproduce
1) Open SSMS 2008
2) Go to File > New Project
3) Give the project a "Name" and the "Solution Name" a separate name (Ensure "Create directory for solution" is checked)
4) Click OK
The Solution Explorer is blank - neither the project nor the solution can be seen. When you browse to the directory where the solution was created, note that there is no solution file. However, the project file gets created. If you double click the project file, it opens in SSMS 2005.
1) We should be able to see the solution and the project up on clicking OK (Step 4 above) in the SSMS Solution Explorer.
2) When double clicking the project file, it should expectantly open in SSMS 2008!?
to post a comment.
Please enter a comment.
on 3/24/2010 at 5:24 AM
Hi Dhaval Patel,
We are considering this issue in our next release. We have multiple issues reported to us for this problem. I reproduced this issue by installing SQL Server 2005 and SQL Server 2008 in the install order that you have mentioned. After uninstalling and installing SQL Server 2008, the issue is resolved. However the projects of SQL Server 2005 stop working after reinstallation.
After more investigation, I am marking this issue as duplicate of http://connect.microsoft.com/SQLServer/feedback/details/390966/class-not-registered-error-when-opening-project-in-ssms . Fixing the issue that we are tracking will fix your issue as well.
Thanks for reporting the issue to us and letting us know the detailed steps to reproduce the issue.
- Vikrant Arora
on 2/13/2009 at 3:00 PM
I had installed SP3 following my installation of SQL Server 2008. I wonder if that screwed things up. Here is my initial installation order:
1) SQL Server 2005 Developer
2) SS 2005 SP1
3) SS 2005 SP2
4) SS 2008
5) SS 2005 SP3
I uninstalled SS 2008 and reinstalled it. It works! I can see the solution as well as the children nodes of the solution. I am not going to try and reproduce the issue because it takes a long time to install on XP.
on 2/13/2009 at 8:07 AM
If you have both SSMS 2005 and SSMS 2008 installed on the same system, please refer to the KB Article:
on 2/13/2009 at 8:05 AM
Dear Dhaval Patel,
Thank you for reporting this issue via connect. Can you check if after creating the project, you get a Project menu and a Close Solution menu item under File menu. Please note that you can open the Solution Explorer by pressing Ctrl+Alt+L at any time.
We suspect your SSMS installation might be corrupt as this problem is not reproducible with SSMS 2008.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft