Need some help from the SQL Gurus out there.
I am periodically getting the following error in our KABA-Autotime (timeclock) database. The front end or interface is a web app.
Error: 1203, Severity: 20, State: 1
Process ID 289 attempting to unlock unowned resource PAG: 6:1:1560968
I have looked at the sql error logs and this error/page number is referenced multiple times in the error log. How can I determine what table this is?
I have tried running Profiler to capture the error, but I haven't been able to successfully capture it and have it display what is happening.
In reviewing a previous post on this error the thought was data corruption. I reviewed the maintenance and the Database Integrity Job has been running successfully.
Server:
SQL Server 2000 SP4 Enterprise Edition
Windows 2003 R2 Enterprise Edition
Any assistance would be greatly appreciated.
Thanks.
MERG
______________________________________
Dilbert: What color do you want the database?