Results 1 to 5 of 5

Thread: Lock Database

  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Unanswered: Lock Database

    In my system I got a problem.
    One of the database's Tables are not getting opened and I can not even alter a Stored Procedure which is related to the tables of that database.
    How can I solve that?
    Subhasish

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Check permissions on the table and also run a DBCC check.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What are the errors you're getting (if any)?

  4. #4
    Join Date
    Oct 2003
    Posts
    83
    Actually I am not getting any error message.
    It simply is not running.
    Even I can not open the database from Enterprise Manager.
    I believe may be due to the overflow of data.
    How can I resolve it?

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    OK, even though confusion is my normal state of mind, it can't be happening that often! First you were talking about inability to open a table and a related stored procedure, and now you're saying you can't open the database from EM??? Which one is it? And what else have you tried, - QA, OSQL, connecting to the server with terminal services and doing the same there, going physically to the server, etc..???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •