SQL Server 2000 and SQL Server 7.0 Support
The following SMO namespaces are not supported by earlier versions of SQL Server:
-
Microsoft.SqlServer.Management.NotificationServices
-
Microsoft.SqlServer.Management.Smo.Broker
-
Microsoft.SqlServer.Management.Smo.Mail
-
Microsoft.SqlServer.Management.Smo.RegisteredServer
-
Microsoft.SqlServer.Management.Smo.Wmi
-
Microsoft.SqlServer.Management.Trace
Partial support for earlier versions is available for Microsoft.SqlServer.Management.Smo.Agent and Microsoft.SqlServer.Management.Smo namespaces.
The classes in the Microsoft.SqlServer.Management.Smo namespace provide support for SQL Server 2000 and SQL Server 7.0 with the following exceptions in:
|
Class
|
Support for Earlier Versions
|
|
Certificate
|
No
|
|
Column
|
Partial
|
|
Credential
|
No
|
|
DatabaseDdlTrigger
|
No
|
|
DatabaseDdlTriggerEvent
|
No
|
|
DatabaseDdlTriggerEventSet
|
No
|
|
DatabaseEvent
|
No
|
|
DatabaseEvents
|
No
|
|
DatabaseEventSet
|
No
|
|
DatabaseMirroringPayload
|
No
|
|
Endpoint
|
No
|
|
EndpointPayload
|
No
|
|
EndpointProtocol
|
No
|
|
HttpProtocol
|
No
|
|
IPExceptionObject
|
No
|
|
MasterKey
|
No
|
|
NumberedStoredProcedure
|
Partial
|
|
NumberedStoredProcedureParameter
|
Partial
|
|
ObjectEvent
|
No
|
|
ObjectEventSet
|
No
|
|
Parameter
|
Paritial
|
|
PartitionFunction
|
No
|
|
PartitionFunctionEvents
|
No
|
|
PartitionFunctionParameter
|
No
|
|
PartitionScheme
|
No
|
|
PartitionSchemeEvents
|
No
|
|
PartitionSchemeParameter
|
No
|
|
Payload
|
No
|
|
Protocol
|
No
|
|
ProtocolIPException
|
No
|
|
Schema
|
No
|
|
SchemaEvents
|
No
|
|
ServerDdlTrigger
|
No
|
|
ServerDdlTriggerEvent
|
No
|
|
ServerDdlTriggerEventSet
|
No
|
|
ServerEvent
|
No
|
|
ServerEventSet
|
No
|
|
ServerTraceEvent
|
No
|
|
ServerTraceEventSet
|
No
|
|
ServiceBrokerPayload
|
No
|
|
ServiceMasterKey
|
No
|
|
ServiceQueueEvent
|
No
|
|
ServiceQueueEventSet
|
No
|
|
SoapMethodObject
|
No
|
|
SoapPayload
|
No
|
|
SoapPayloadMethod
|
No
|
|
SqlAssembly
|
No
|
|
SqlAssemblyEvent
|
No
|
|
SqlAssemblyEvents
|
No
|