I am using sql server 2005 express edition.
The database is filled up to 700 MB. it is giving error like
"Transaction (Product Id 54) was dead lock resources with another process and had been chosen as dead lock victim returns transaction."
I am getting this error for this we are restarting sql server. Then it is working fine for 2 hours after that it is giving same error with diferent product id like 59 etc.
our clients nearly 1000.
I didn't find what is problem.
Please solve my problem. Because my application in production.
Thanks in Advance.
View Complete Post