I wouldn't say much more complicated... there are a few more joins yes... but there are around 10 of those statements in the query... so I didn't think...

Hi Chris,

I didn't yet - but I will.

I have added COMMITTED SNAPSHOT isolation as it was the least invasive - i.e. didn't need to change any code. ...

Thanks Gavin / Gail and Grant.

Here is a link to the deadlock graph. Pretty much always shows the Job being killed and always the same table and key. ...

Thanks Grant and Gail.

XDL for deadlock is here

https://www.dropbox.com/s/aonjva56erfe9ft/TraceDeadLockXML.xdl?dl=0

Thanks for all the advise... I am going to check the scans / improve the update times - hopefuly this...

Nice simple solution.

Thanks for that... will be useful.

Thanks again.

Love it when you have a problem, find someone with the same issue, and no solution.

🙂

Oh well..

Will keep looking...

Ok... now I feel like an idiot...

Thank you.. not sure how I deleted the @..

Thanks again

Hi Gail and Grant,

Thanks for the replies..

I started trying to create DDL statements for all the tables required, I was on 25 tables just now, as they...

Hi,

I have had this happen to me as well.

I ended up using something like this :

exec sp_dropserver 'A'

exec sp_addserver @server='NewName', @local='local'

Then check the return of...

ItemCodeDateSalesPurchasesEndingInventoryFreeToSell

A2006-06-01 00:00:00.000228132011021102

A2006-07-01 00:00:00.00040481258745874

A2006-08-01 00:00:00.0000177576497629

A2006-09-01 00:00:00.00020076297629

A2006-10-01 00:00:00.000029751060410604

A2006-11-01 00:00:00.000001060410604

A2006-12-01 00:00:00.00004001100411004

Your solution is almost right.. will see if I can resolve this.. as just the first couple are incorrect...

The Free to Sell...

Hi Guys...

Thanks for the responses...

I don't really have the choice of doing it on the client, as I need this figure to put on a table so the users...

Used the DBCC Rebuild_Log idea, and it worked like a charm.

Thanks.

The stored proc above would have worked too, but since I had many mdf files... it would have been more...

EM gives the same message....

I read here... http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp

that if you have 2 files it will give an error... but was hoping there was another solution....

Identical error...