Post reply

error818 in SQL 2k

  • April 16, 2003 at 11:13 am

    #159484

    Hi,

    yesterday I received an Error: 818, Severity: 19, State: 1 message from one of my sql servers. I have tried looking around for descriptions, but have come to no real conclusions so far. If anyone could help me I would appreciate it.

    Below is the error description that I am getting.

    There is no room to hold the buffer resource lock BUF pointer = 0x11be600, page ptr = 0xa2f20000, pageid = (0x1:0x15db5), dbid = 2, status = 0xb, file = H:\MicrosoftSQLServer\MSSQL\data\tempdb.mdf in SDES SDES pointer = 0x33f3700. Contact Technical Support.

    Thanks

    Tom

  • April 16, 2003 at 11:20 am

    #454409

    Check out this:

    http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b198653

    -SQLBill

  • April 16, 2003 at 11:32 am

    #454412

    Bill,

    Thanks, I have already looked at that one. From how I am the kb, that process will lock the table(s) and block others, and in order to remove the lock, you need to re-start the service. But, the spid was dropped ?? and a new connection has already taken that ID.

    Tom

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

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