Post reply

Error: 1203 ... attempting to unlock unowned resource PAG: 6:1:1560968

  • August 8, 2007 at 12:53 pm

    #69672

    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?

  • August 8, 2007 at 1:45 pm

    #725528

    There is a fix for this in SP4.  Are you sure you are on SP4?  If so, run a DBCC CHECKDB.  If it comes up with errors, fix them.  If it comes up clean, contact Microsoft.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply