September 9, 2008 at 3:03 am
I am getting the following error on a SQL Server 2005 instance.
“Process ID 65 attempted to unlock a resource it does not own: OBJECT: 9:1200723330:0 . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
Date05/09/2008 07:03:25
LogSQL Server (Current - 09/09/2008 09:04:00)
Sourcespid65
Message
Error: 1203, Severity: 20, State: 1."
plz let me know, what is the solution of this problem.
Thanks in advance.
Regards,
Mohammed.
________________________________________
M.I.
[font="Times New Roman"]
September 9, 2008 at 3:32 am
Severity level indicates that this error may be due to any hardware problem or may be due to any external software problem other than SQL Server. You may think on these lines depending upon the script executed. Also track the spid65 functionality in your case.
DBDigger Microsoft Data Platform Consultancy.
September 9, 2008 at 4:15 am
How about looking at the fine Microsoft documentation?
Try this... http://msdn.microsoft.com/en-us/library/aa337285.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply