Home Forums SQL Server 2008 T-SQL (SS2K8) MERGE Statement DELETE from TARGET when not in SOURCE 'hanging' RE: MERGE Statement DELETE from TARGET when not in SOURCE 'hanging'
Cowboy DBA
SSCrazy
Points: 2135
More actions
June 21, 2013 at 7:21 am
#1626310
When you say "hanging" what do you mean? I take it as there is something blocking which in turn implies that the update would not complete.
Like I said, check any blocking SPIDs and also check the query plan of your statement.