Some of our users here are locking up on the HQ client. When I check SQL Activity I see SPID so and so is blocking another SPID who is blocking another SPID etc.
The first SPID that is doing the blocking is running the query at the bottom of this post. I'm wondering if anyone else has seen this problem. It just started today. What I did is create separate SDL users for each client PC so i can see which login is the source of the problem. Because a few of our users are on terminal server they all show up on TERMSERV in the SQL activity monitor. By having seperate users, I will try to determine the source if there is one.
Now if it is a worksheet trying to run I don't know how I will see that. Maybe it will be running under SA on the RMS server.
Has anyone else seen this or had a problem like it? Any information will be greatly appreciated.
Thanks,
Scott Emick
UPDATE [ItemDynamic] WITH (TABLOCKX) SET [ItemDynamic].[SnapShotQuantity] = #Temp.[SnapShotQuantity], [ItemDynamic].[SnapShotQuantityCommitted] = #Temp. [SnapShotQuantityCommitted], [ItemDynamic].[SnapShotPrice] = #Temp.[SnapShotPrice], [ItemDynamic].[SnapShotPriceA] = #Temp.[SnapShotPriceA], [ItemDynamic].[SnapShotPriceB] = #Temp.[SnapShotPriceB], [ItemDynamic].[SnapShotPriceC] = #Temp.[SnapShotPriceC], [ItemDynamic].[SnapShotSalePrice] = #Temp.[SnapShotSalePrice], [ItemDynamic].[SnapShotSaleStartDate] = #Temp.[SnapShotSaleStartDate], [ItemDynamic].[SnapShotSaleEndDate] = #Temp.[SnapShotSaleEndDate], [ItemDynamic].[SnapShotCost] = #Temp.[SnapShotCost], [ItemDynamic].[SnapShotLastCost] = #Temp.[SnapShotLastCost], [ItemDynamic].[LastSold] = #Temp.[LastSold], [ItemDynamic].[LastReceived] = #Temp.[LastReceived], [ItemDynamic].[SnapShotReplacementCost] = #Temp. [SnapShotReplacementCost], [ItemDynamic].[SnapShotPriceLowerBound] = #Temp. [SnapShotPriceLowerBound], [ItemDynamic].[SnapShotPriceUpperBound] = #Temp. [SnapShotPriceUpperBound], [ItemDynamic].[SnapShotReorderPoint] = #Temp.[SnapShotReorderPoint], [ItemDynamic].[SnapShotRestockLevel] = #Temp.[SnapShotRestockLevel], [ItemDynamic].[SnapShotTaxID] = #Temp.[SnapShotTaxID], [ItemDynamic].[SnapShotTime] = #Temp.[SnapShotTime] FROM [ItemDynamic], #Temp WHERE [ItemDynamic].[ItemID] = #Temp.[ItemID] AND [ItemDynamic].StoreID = 46