INSERT & UPDATE not working all of sudden

  • Hi There,

    I have a weired problem going on one of my SQL Server 2000 database where other databases are working fine on the same server.

    We have a "Products" database on our server but its stop working all of sudden & not inserting or updating few tables (ex: 'Table A', 'Table K') unless we stop & re-start the sql services again. Is there anything particular we should do on these specific tables or there is total wrong with entire "Product" database?

    Please help me in this regard how we could solve this issue.

    Thanks in advance

    Mike

  • nobody has answered and you must be in a panic.

    How do you know that inserts and updates aren't working?  Are you getting any sort of a message?  Have you looked in the logs?  Do your users get a message?  Post a bit more information.  Where are you DB files located?  Do you have space on the device?

    Before you do anything dangerous, think backup... do you have one?

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • Okay, so you cross posted and people are helping you there...

    Let's close this thread now.

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

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

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