We have come across a situation where linked server connection cann't be kill except restarting sql server which is too intrusive on production environment.Any suggestion please.we are using sql 2008r2 enterprise edition and linked server is extracting data from progress using 64 bit odbc driver.

What syntax are you using to end the linked server and what is the error message you get? Moderators: This post should also be moved to SQL Server Database Engine Forum http://social.msdn.microsoft.com/Forums/en-AU/sqldatabaseengine/threadsJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

we were using Kill command to kill linked server spid.

No wonder you're having problems. That's like using Task Manager to kill tasks! Use sp_dropserver 'servername', 'droplogins'Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker