Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks AlfredI found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard|||try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfredsql
Friday, March 30, 2012
How can i remove a server from enterprise manager
Labels:
2000how,
availablefor,
database,
enterprise,
example,
manager,
microsoft,
mysql,
oracle,
registrations,
server,
servers,
sql,
sql-server,
whenthe
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment