SMO and Sql Server 7.0

Question :

SMO and Sql Server 7.0,

Answer :

Does anyone have a definitive answer to whether  is compatible with Sql Server 7.0?
The docs state:

Because SMO is compatible with SQL Server version 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008, you easily manage a multi-version environment.

But trying to connect to a Sql 7 instance gets me:

“This SQL Server version (7.0) is not supported.”

Has anyone been successful in getting these 2 to play nice?

,

you can use SMO to connect to SQL Server versions 7, 2000, and 2005, but SMO does not support databases set to compatibility levels 60, 65, and 70.

for SQL Server 7.0 the compatibility level is 70

Read More  Ajax Control Toolkit Calendar Control CSS

Obviously this is conflicting information…I assume if your compatibility level of your DB is 70 you can not connect.

To check run: EXEC sp_dbcmptlevel ‘databasename

it seems you might be able to change the compatibility level by running this:

EXEC sp_dbcmptlevel ‘databasename‘, 80

Obviously make a back up before changing anything.

That’s the answer SMO and Sql Server 7.0, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.

Read More  Is there any way to enable code completion for Perl in vim?

Disclaimer :

The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you