I have Sql Server 2005 and 2008 installed on my PC. By default 2008 is running and it is connected in visual studio 2010.
How could I make Sql server 2005 as default sql server and make connection with VS 2010.
Thank You
(Please tell me solutions without Uninstalling any of the Sql servers.)
Its not really clear what's being asked here, but it could be
1) How do I find out if SQL 2005 is installed and what is its instance name.
John Hartsocks answer to SQL Server 2008 installed, though running version is still 2005 would recommend
...View All services using the Service Control Manager. Here you will need to look at what instances of SQL Server you have running on the machine.
I also have answer to that question that uses PowerShell if you're so inclined.
2) How do I make connection with VS 2010
For this you'll need to be more specific. Are you asking about Entity Framework, Linq To SQL, Object Data source question? Perhaps you're just asking about the Server Explorer window?
精彩评论