I've installed SQL Server 2005 RTM and using Microsoft's sample on
connecting using SMO, I tried connecting to a SQL Server 7.0 server. I
received this error:

"This SQL Server version (7.0) is not supported".

Huh?! BOL says SMO supports 7.0.

Hi

Are you on the SP4 for SQL Server 7.0?
I don't have a version I can test on, but it might be that SP4 is required
for it to work with SQL Server 7.0

Also check that you are not using functionality that is not supported:
BOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/smo9/html/6527388b-26b5-4ebb-8a52-0cf4415f9134.htm

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quoteHide quote

Johnny Ortega (john.ort***@quest.com) writes:
Sounds bad. But exactly which sample did you use? Most of the samples I
could find for SMO looks like the explore features only in SQL 2005? I'm
not into SMO myself, so I cannot just write a quick script that works on
SQL 7. (And neither can I rule out that documentation and implementation
are out of sync.)

The uninstall of sql server 2005 beta and visual studio 2005 is a mess
Consecutive values
Random number generation with seed value
Compute sum of count(*) with group by
Copying records from one table to another