Get a list of sql servers, is .ServerName deprecated?

[=?Utf-8?B?cm9nZXJfMjc=?=]

http://www.sqldbatips.com/showarticle.asp?ID=45

the tutorial I am looking at.

I copied the last method. and I am using the following references

using System;
using System.Collections.Generic;
using System.Text;
using System.Diagnostics;
using System.Data;
using Microsoft.Win32;
using Microsoft.SqlServer.Management;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.RegisteredServe rs;
using Microsoft.SqlServer.Server;
using System.Windows.Forms;

the problem is here...

....
foreach (RegisteredServer rs in rsvrs)
{
String name = "";

name = rs.ServerName.Replace...

there is no method called ServerName.

There is ServerInstance and Name, but not ServerName . am I missing an
assembly or reference? is ServerName deprecated ? thanks.

[j1mb0jay]

roger_27 wrote:

http://www.sqldbatips.com/showarticle.asp?ID=45

the tutorial I am looking at.

I copied the last method. and I am using the following references

using System;
using System.Collections.Generic;
using System.Text;
using System.Diagnostics;
using System.Data;
using Microsoft.Win32;
using Microsoft.SqlServer.Management;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.RegisteredServe rs;
using Microsoft.SqlServer.Server;
using System.Windows.Forms;

the problem is here...

...
foreach (RegisteredServer rs in rsvrs)
{
String name = "";

name = rs.ServerName.Replace...

there is no method called ServerName.

There is ServerInstance and Name, but not ServerName . am I missing an
assembly or reference? is ServerName deprecated ? thanks.

Try reading this the SQLDMO is what you want to be using.

http://www.csharphelp.com/archives2/archive342.html
--
Regards JJ (UWA)