June 2015
Intermediate to advanced
1800 pages
70h 6m
English
To unregister linked servers, you can use sp_dropserver. Only members of the sysadmin and setupadmin fixed server roles can execute this stored procedure:
sp_dropserver [@server =] 'server' [, [@droplogins =] {'droplogins' | NULL}]
The elements of the syntax are as follows:
server—The linked server that will be unregistered.
droplogins—An argument that specifies the logins associated with the server should be dropped. If this argument is not specified, the server is dropped only if logins do not exist ...
Read now
Unlock full access