database problem

  • 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

  • It is not an error, the extended stored procedure is used to read values from the registry. I doubt that it is related to your problems.

    --------------------------------------------------------------------------------------
    [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]

  • Do you have some sort of job or large query that runs at a regular interval that might be causing a table lock?

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

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