Archive | Linked Server RSS feed for this section

Rolling Back (or is it??)

by Mike Walsh on 31. Dec, 2008 in DMV, Linked Server, SQL Server 2005, Syndicate, Troubleshooting

Interesting Issue Today/Yesterday -
A query was using a linked server to grab data from DB2 via an ODBC connection. Normal execution time is about 15 minutes. This had run on for at least 7 hours when it was decided to kill it, appeared to be doing nothing but causing blocks (due to Intent Shared and [...]

  • Share/Bookmark
Read full story • Comments { 0 }