THIS AS TAKEN UP MOST OF MY MONDAY --- I am attempting to run the following:
WHEN I RUN IT - IT SHOWS EXECUTING QUERY - BUT IT RUNS FOREVER (2 hrs, 36 min)AS OF THIS MESSAGE - NEVER TIME'S OUT OR GIVES AN ERROR
EVERYTHING WORKS FINE WHEN I RUN THE FOLLOWING:
CAN SOMEWHERE EXPLAIN TO ME WHAT'S GOING ON - AND A POSSIBLE SOLUTION......
THANKS IN ADVANCE . . . . .
Way of performing Update statement on Linked Server-
Please rewrite your query and check again.
Can you observe the linked server? Is your process blocked? How about the wait stats on the server you're on. What is that process waiting on? Check sys.dm_exec_requests as a starting point.
answered Jan 03, 2012 at 08:25 AM
Grant Fritchey ♦♦