Edit

Share via

Files and version numbers

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL database in Microsoft Fabric

All required SQL Server Management Object (SMO) components are included in the Microsoft.SqlServer.SqlManagementObjects NuGet package. SMO is implemented in several managed assemblies. You can develop SMO applications on either a client or a server.

Remarks

The file version of the SMO assemblies is displayed as Major.0.Build.Revision. But the embedded assembly version is Major.100.Build.Revision. This is done to keep the version of SMO used in each application separate, so updates to one don't affect any others.

For this reason, don't install the NuGet version of SMO assemblies to the Global Assembly Cache (GAC). Doing so could cause other applications, including SQL Server Management Studio, to break.

File and version information

File Description
Microsoft.SqlServer.ConnectionInfo.dll Contains support for connecting to an instance of SQL Server.
Microsoft.SqlServer.ServiceBrokerEnum.dll Contains support for programming the Microsoft Service Broker. This is required only in programs that access the Service Broker.
Microsoft.SqlServer.Smo.dll Contains the most of the SMO classes.
Microsoft.SqlServer.SmoExtended.dll Contains support for the SMO classes.
Microsoft.SqlServer.Management.Sdk.Sfc.dll Contains support for the SMO classes.
Microsoft.SqlServer.SqlEnum.dll Contains support for the SMO classes.
Microsoft.SqlServer.WmiEnum.dll Contains the Windows Management Instrumentation (WMI) Provider classes. This is required only for programs that use the WMI Provider classes.
Microsoft.SqlServer.RegSvrEnum.dll Contains the Registered Server classes. This is required only for programs that use the Registered Server classes.