I have used Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.ConnectionInfo.dll in a number of VS2008 projects but they don't appear in the VS2010 Add Reference dialog. Why did they disappear and how can I add them to my VS2010 project?
+1
A:
I'm pretty sure when I've used those I've always added by browsing to the DLLs themselves (but we're restricted to 2005 at work).
Cade Roux
2010-06-17 00:26:06
A:
As far as I know, those assemblies are installed if and when you install the SQL Server client-side tools. They should be visible in the .NET tab of your Add Reference dialog, for sure (if you installed those SQL Server client side tools).
You can also download those libraries separately directly from Microsoft and re-install them. That sometimes helps to "get them back" :-)
Go here: SQL Server 2008 Feature Pack and find the Microsoft SQL Server 2008 Management Objects about half way down on the page and download the package you need and install that.
marc_s
2010-06-17 05:23:27
The assemblies are installed on my system (they appear in VS2008's Add Reference dialog but not in VS2010's.) I tried reinstalling from your link (thanks) but got a message that newer version were already installed.I can add the reference by browsing to the DLLs as Cade Roux suggests but I'm curious about why they don't appear in VS2010.
Sisiutl
2010-06-17 15:17:57