TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Drop Linked Server IN Sql Server
Manish Dwivedi
Mar 01, 2011
37.8
k
0
1
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
This blog will tell you, how to delete LinkedServer.
In previous blog I told you about to add LinkedServer, if you haven't read that blog then
Read Here
In this blog I am going to tell you, how to delete LinkedServer.
Execute this command from master DB.
EXEC
sp_dropserver
'LinkedServerName'
,
'droplogins'
This command removes the remote server servername and all associated remote logins from the local SQL Server.
You can also verify by executing this query.
SELECT
*
FROM
sys
.
servers
Drop Linked Server IN Sql Server
Next Recommended Reading
Could Not Find Server 'Server Name' In sys.servers In SQL Server