Hi,

Which URL is the correct one?

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.sqlserverregistrations.enumregisteredservers(v=SQL.105).aspx

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.registeredservers.registeredserver.aspx

There are many other URLs. How to make sure that you are reading the last one ?

Hi DbDefence,

>>http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.sqlserverregistrations.enumregisteredservers(v=SQL.105).aspx
EnumRegisteredServers is a method from SqlServerRegistrations class, which is used to return an array of registered servers. The SqlServerRegistrations class can stand for more than one registered server.

>>http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.registeredservers.registeredserver.aspx
RegisteredServer is a class which can be used to initializes a new instance of the registered server.

Both of these two classes (under Microsoft.SqlServer.Management.Smo and Microsoft.SqlServer.Management.Smo.RegisteredServers
 name space) are obsolete, which means that a better alternative is available so this is now deemed redundant and they will probably be discontinued in the next release. You can use Microsoft.SqlServer.Management.RegisteredServers namespace which supersedes the Microsoft.SqlServer.Management.Smo.RegisteredServers namespace. It is available with SQL Server 2008 and contains classes that represent the SQL Server Registered Servers service.

For more information: Microsoft.SqlServer.Management.RegisteredServers Namespa

Hello,

I think that code samples are missing to understand how to use correctly both SqlServerRegistrations and RegisteredServer ( from the Microsoft.SqlServer.Management.Smo.RegisteredServer ). It would be useful how they are working...

Have a nice day

Hi

Is there an SMO created in .net by microsoft, because as i see it, there is no help line available with methods, and not too many events . It just doesn't seem like a .net created dll. nowhere can we see Overlaods for any Procedure.

Is SMO an Obsolete issue, or is microsoft going to come out with a New one, or what ????

My question is , can we use SMO without any hassles. Are Microsoft coming with a Newer version where we have more Exceptions and Events etc...

I am using VS 2010 and SQLServer 2008 R2 Express. I have also installed SharedManagementObjects.msi, just as an upgrade, but could not find Microsoft.SqlServer.Management.RegisteredServer.dll anywhere.

Regards,

Bikram Grewal

You have to look on your PC for the *RegisteredServer.dll.
You will find it for SMO 11(2012) or older under GlobalAssemblyCache  ..\GAC_MSIL\.. .

Hi John ,

the .msi depends of the version of the SQL Server version

For 2014 :

http://www.microsoft.com/en-us/download/details.aspx?id=42295

for a X86 (32 bits ) , you have to use the ENU\x86\SharedManagementObjects.msi

for a X64 (64 bits ) , you have to use the ENU\X64\SharedManagementObjects.msi

Don't forget to read this

"Microsoft SQL Server 2014 Shared Management Objects

SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.

Note: Microsoft SQL Server Management Objects requires -  Microsoft SQL Server System CLR Types, that is available on this page.


Filename: X86 and x64 Package(SharedManagementObjects.msi)"

You should have a look at

Microsoft System CLR Types for Microsoft SQL Server 2014
The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server 2014.  This component can be installed separately from the server to allow client applications to use these types outside of the server.

Note: This component also requires Windows Installer 4.5

Filename: X86 and x64 Package(SQLSysClrTypes.msi)

For SQL Server 2012 , it is a little more complicate as the feature pack is depending of the Service pack ( RTM , SP1 , SP2 , ...)

RTM : http://www.microsoft.com/en-us/download/details.aspx?id=29065

SP1 : http://www.microsoft.com/en-us/download/details.aspx?id=35580

SP2 : http://www.microsoft.com/en-us/download/details.aspx?id=43339

Don't forget the difference X86/X64 and the CLR download

Have a nice day

thank you for the information. but the file I was referring to was for

vb2010 and sqlserver 2008 r2. 

I am sorry for this error.

For SQL Server 2008 R2 SP1 : http://www.microsoft.com/en-us/download/details.aspx?id=26728

For SQL Server 2008 R2 SP2 : http://www.microsoft.com/en-us/download/details.aspx?id=30440

For SQL Server 2008 R2 SP3 : http://www.microsoft.com/en-us/download/details.aspx?id=44272

I hope one of these links can help you.

Have a nice day