Friday, March 23, 2012

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?
SubhasishCheck permissions on the table and also run a DBCC check.|||What are the errors you're getting (if any)?|||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?|||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..?sql

No comments:

Post a Comment