problem with name space: Imports Microsoft.SqlServer.Management.Smo

[Eric S]

Hi All,

I am getting the below warning when loading a project that used to work with
ms sql 2005. I installed ms sql 2008 enterprise version and removed the ms
sql 2005. I suspect that could be the reason for the below warining. How
that could be fixed?

Apprecaite any feedback.....

Imports Microsoft.SqlServer.Management.Smo

Warning 1
Namespace or type specified in the Imports
'Microsoft.SqlServer.Management.Smo'
doesn't contain any public member or cannot be found. Make sure the
namespace
or the type is defined and contains at least one public member. Make sure
the
imported element name doesn't use any aliases.

Thanks,

Eric

 

[Eric S]

Hi Kornel,

I am getting also errors due to the below. Is that dll part of ms sql 2005?
Since ms sql 2005 was removed and installed ms sql 2008. Looking at the
Assembly folder and the microsoft.sqlserver.smo.dll is found on that folder.

You mean I will need to repair the ms sql 2008?

Thanks,

Eric

 

[Eric S]

Thanks

Hi,

I have that file in "C:\Program Files\Microsoft SQL
Server\100\SDK\Assemblies\Microsoft.SqlServer.Smo.dll"

I don't know if that is included in SQL Server 2008.

You also should check if GAC has that file.

Kornél