Database table lock

  • hi all,

    I have Sql server 2000 on Windows 2000.

    Recently i faced this error our database tables are getting locked automatically in interaval of 4-5hrs.

    And in current activity log i saw this error

    Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'xp_instance_regread'.

    Wat does this error imply? and why tables are getting lock and unable to release?

    Thanks,

    Neerav

  • swear i answered this one about 10 minutes ago.

    it is not an error, just an informational, just telling you that it called a extended stored procedure to read some values from the registry.

    Check the rest of the sql log, for the times that you had problems and see if you can find anything else.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

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

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