August 30, 2013 at 3:27 pm
How to unlink a linked server?
I have two database server and i just want to unlink them from each other.
August 30, 2013 at 4:49 pm
This example removes the remote server servername and all associated remote logins from the local SQL Server.
sp_dropserver 'servername', 'droplogins'
August 30, 2013 at 4:51 pm
Alternately, You can execute sp_dropserver for all linked servers using the database cursor. The following example shows how to do this.
DECLARE @sql NVARCHAR(MAX)
DECLARE db_cursor CURSOR FOR
select 'sp_dropserver ''' + [name] + '''' from sys.servers
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @sql
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC (@sql)
FETCH NEXT FROM db_cursor INTO @sql
END
CLOSE db_cursor
DEALLOCATE db_cursor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy