There are still remote logins or linked logins for the server 'linkedservername'

There are still remote logins or linked logins for the server 'Linked server name'

Steps by Step 

1.  Open SQL Server Management Studio, Run (press F5) this query  SELECT * FROM sys.servers  Query returns all the linked servers created 
2. Run ( press F5)  exec sp_dropserver 'XXXX'    Replace XXXX with your linked server name  which is  the second column value of your step 1 query results
3.  Run (press F5)   exec sp_droplinkedsrvlogin  'XXXX','YYYYY'   Replace XXXX with your linked server name  which is the second column value of your step 1 query results,  Replace YYYY with NULL
4. That's it. Now you will not receive error .
5. Sample