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

[Kornél Pál]

Hi,

I you have no compilation errors then just remove the Imports line. If
you have compilation errors because of missing classes then you should
add a reference to the assembly file (microsoft.sqlserver.smo.dll)
contatining that namespace.

If you are missing that assembly you should reinstall (repair) SQL Server.

Korn�l

[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

"Korn�l P�l" <korn...@newsgroup.nospam> wrote in message
news:uHgeIAcy...@TK2MSFTNGP06.phx.gbl...

> Hi,
>
> I you have no compilation errors then just remove the Imports line. If you
> have compilation errors because of missing classes then you should add a
> reference to the assembly file (microsoft.sqlserver.smo.dll) contatining
> that namespace.
>
> If you are missing that assembly you should reinstall (repair) SQL Server.
>

> Korn�l

[Kornél Pál]

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

Eric S wrote:
> 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
>

> "Korn�l P�l" <korn...@newsgroup.nospam> wrote in message

> news:uHgeIAcy...@TK2MSFTNGP06.phx.gbl...
>> Hi,
>>
>> I you have no compilation errors then just remove the Imports line. If you
>> have compilation errors because of missing classes then you should add a
>> reference to the assembly file (microsoft.sqlserver.smo.dll) contatining
>> that namespace.
>>
>> If you are missing that assembly you should reinstall (repair) SQL Server.
>>

>> Korn�l

[Eric S]

Thanks

"Korn�l P�l" <korn...@newsgroup.nospam> wrote in message
news:OC6NrRdy...@TK2MSFTNGP03.phx.gbl...

> 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

>
> Eric S wrote:
>> 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
>>

>> "Korn�l P�l" <korn...@newsgroup.nospam> wrote in message

>> news:uHgeIAcy...@TK2MSFTNGP06.phx.gbl...
>>> Hi,
>>>
>>> I you have no compilation errors then just remove the Imports line. If
>>> you have compilation errors because of missing classes then you should
>>> add a reference to the assembly file (microsoft.sqlserver.smo.dll)
>>> contatining that namespace.
>>>
>>> If you are missing that assembly you should reinstall (repair) SQL
>>> Server.
>>>

>>> Korn�l