Where can I find Microsoft.SqlServer.Management.Smo?

Question

 

Where can I find Microsoft.SqlServer.Management.Smo?  Is this a separate download?

 

Answer 1

I found a post in this forum saying that I should download SQLServer2005_XMO.msi

which I did and ran, but I still cannot find the assembly when I try to add a reference to my VS2008 project.

 

 

Answer 2

By default the DLL files are in directory C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

 

Hope that helps.

Answer 3

I finally found it.  When a do a Add Reference in VS2008, it is in Microsoft.SqlServer.Smo.

Answer 4

Hello,

 

Don't forget Microsoft.SqlServer.ConnecttInfo

 

Have a nice day

Answer 5

Yes Thanks that helped... now searching the import for  Microsoft.SqlServer.Dts.Runtime

---

~Mohan

Answer 6

Hello,

Have you tried in  C:\Program Files\Microsoft SQL Server\90\DTS ?

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 7

if i cnt found the C:\Program Files\Microsoft SQL Server\90\SDK folder~how i gotta find the Microsoft.SqlServer.Management.Smo?

Answer 8

Hi,

using Microsoft.SqlServer.Management.Smo;

Using Microsoft.SqlServer.Management.Common;

you found DLL in.... C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies

Microsoft.SqlServer.Smo.dll;

Microsoft.SqlServer.ConnectionInfo.dll

Bye

Answer 9

Did you try adding Microsoft.SqlServer.SmoExtended.dll??

My SQL SERVER 2008 have this and adding this reference helped me.