SQL 2008: Missing Microsoft.SqlServer.SmoEnum.dll

Question

I'm unable to find:

C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.SmoEnum.dll

Per the MSDN Library, it should have been installed as part of SQL Server installation: http://msdn.microsoft.com/en-us/library/ms162161.aspx

Am I misunderstanding something?

Thanks in advance.

Answer 1

Hi

Microsoft.SqlServer.SmoEnum.dll is available in SQL Server 2005 and is removed from SQL Server 2008. If you have a SQL Server 2005 installed in any machine, it would be under C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies folder But the dll wont be available in the C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies directory.


the link in msdn shows the wrong directory. Thanks for pointing out.

Thanks
Sreekar
SQL Server Manageability

Answer 2

Sreekar:

 What are my options since I cannot install SQL 2005 on this server?  Is there a "replacement" dll?  The C# program I'm using is referencing "Urn" and that would be found in that dll.

Thanks,

Lisa

Answer 3

Hi

Microsoft.SqlServer.SmoExtended.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll

Above dlls are newly added in SQL Server 2008 which might be useful for your case.

The other dlls useful for your case in both versions are

Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SqlEnum.dll

Thanks
Sreekar

Answer 4

Sreekar:

I'm trying those out now.  Hopefully, I can get it to work.

Thanks for your help.  If this solution works, I will mark it as answered.

Answer 5

Hi

Can you please reply if the above dll worked out whether it is available in SQL Server 2008 or not?

Thanks
Sreekar

Answer 6

It did work.  (I had said in my previous post that I would mark this question "answered" if the dll worked.)

Thanks for checking.