ListCompatibilityLevels (DMO) Problem in Yukon

Hello,
The ListCompatibilityLevels ( Property of SQLDMO.SQLServer2 Object) does not
work properly for YUKON.
It does not report the 'Database compatibilty level 90'.
Please Help.
TIA
Regards
Vaibhav Tole.That's probably because it has no clue about any of Yukon's features or even
a compatibility level above 80. If you want to ensure full compliance with
2005 you need to use SMO not DMO.
Andrew J. Kelly SQL MVP
"Vaibhav" <vaibhavtole@.yahoo.com> wrote in message
news:eoXWSMWOGHA.2816@.TK2MSFTNGP15.phx.gbl...
> Hello,
> The ListCompatibilityLevels ( Property of SQLDMO.SQLServer2 Object) does
> not work properly for YUKON.
> It does not report the 'Database compatibilty level 90'.
> Please Help.
> TIA
>
> Regards
> Vaibhav Tole.
>|||Hello ,
Thx for that Info.
Do you know about how to "List compatibilty levels " by SMO ?
The DMO to SMO map ( msdn
:http://msdn2.microsoft.com/en-us/library/ms162159.aspx
)
tells us that the funtionality has been moved to "server" object.
T I A
Vaibhav
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eSmaO4WOGHA.3944@.tk2msftngp13.phx.gbl...
> That's probably because it has no clue about any of Yukon's features or
> even a compatibility level above 80. If you want to ensure full
> compliance with 2005 you need to use SMO not DMO.
> --
> Andrew J. Kelly SQL MVP
>
> "Vaibhav" <vaibhavtole@.yahoo.com> wrote in message
> news:eoXWSMWOGHA.2816@.TK2MSFTNGP15.phx.gbl...
>|||These should get you started:
http://msdn2.microsoft.com/en-us/li...ilitylevel.aspx
http://msdn2.microsoft.com/en-us/library(d=robot)/ms162557.aspx
http://www.sqldbatips.com/showarticle.asp?ID=34
Andrew J. Kelly SQL MVP
"Vaibhav" <vaibhavtole@.yahoo.com> wrote in message
news:OAiI5Q1OGHA.3272@.tk2msftngp13.phx.gbl...
> Hello ,
> Thx for that Info.
> Do you know about how to "List compatibilty levels " by SMO ?
> The DMO to SMO map ( msdn
> :http://msdn2.microsoft.com/en-us/library/ms162159.aspx
> )
> tells us that the funtionality has been moved to "server" object.
>
> T I A
> Vaibhav
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eSmaO4WOGHA.3944@.tk2msftngp13.phx.gbl...
>