A System Security Officer can use sp_dropserver to drop servers from sysservers. The syntax is:
sp_dropserver server [, droplogins]
where:
server – is the name of the server you want to drop.
droplogins – allows you to drop a remote server and all of that server’s remote login information in one step. If you do not use droplogins, you cannot drop a server that has remote logins associated with it.
The following statement drops the GATEWAY server and all of the remote logins associated with it:
sp_dropserver GATEWAY, droplogins
You do not have to use droplogins to drop the local server; that entry does not have remote login information associated with it.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
