Re: How can I scan for named instances of SQL?
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Thu, 16 Feb 2006 14:43:51 +0200
Byron
Do you use SQLDMO objects library?
The OLE DB Provider for SQL Server 2000 returns instance names using
ISourcesRowset::GetSourcesRowset
SQL-DMO applications can enumerate instances using the SQLServer2
object. The SQLServer2 object also presents information such as the names of
the SQL Server and SQL Server Agent services for the instance, or whether
the instance is running on a single computer or a failover cluster. For more
information, see SQLServer2 Object
"Byron" <Byron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:74EC9B24-45FE-4A8D-B0CF-E5DB412C3E70@xxxxxxxxxxxxxxxx
I need to periodically scan our network for SQL installations and sometimes
affect all servers to do things like change the sa password. Since the
servers are far-flung without technical people on-site I can't rely on
anyone
there to keep me up to date. I wrote a little C# app that can locate all
the
default instances, but it can't discover named instances.
Ideally I'd like to add the capability to discover named instances to the
samer application, but any other discovery method would be appreciated.
.
- Follow-Ups:
- Re: How can I scan for named instances of SQL?
- From: Joe Yong
- Re: How can I scan for named instances of SQL?
- Prev by Date: Re: 'Domain\LocalServer$' is not a valid user
- Next by Date: Re: Move 10 DBs and provide dev access thru EM?
- Previous by thread: Change SQL Instance name to default(local) instrance
- Next by thread: Re: How can I scan for named instances of SQL?
- Index(es):
Relevant Pages
|
|
