October 9, 2006 at 11:36 am
Hello all,
I'm hitting an usual problem that just started last week, the DB in question has been fine for months.
On one particular database when viewed in SQL Manager, when you right click on a table Manager either stops responding or after a few minutes we get this error:
"You might not have permission to perform this operation, or the object <table name> might no longer exist in the database. (MS Visual Database Tools)."
It does not happen with any other database besides our core ASP.NET application db.
Restarting SQL Server, and reindexing the DB seemed to help last Friday, now it's happening right away after either of those steps. Could fragmentation alone do this? Could SSIS packages have something to do with this?
Searching MSBD has not yielded anything relevant for "SQL 2005 Manager Open Table Error".
thanks a million!
Skål - jh
October 10, 2006 at 12:31 pm
How many rows in the table? the "open table" feature has problems large tables (millions of rows).
---------------------------------------
elsasoft.org
October 10, 2006 at 12:39 pm
In this case there are only six rows in the table.
We cannot find anything besides some minor fragmentation on the server.
I suspect I'll need to remove and re-install SQL 2005 client tools.
Skål - jh
October 10, 2006 at 7:48 pm
Do you have some trigger defined on the table?
Can you run profiler trace i the backgroup and see the error?
October 11, 2006 at 10:06 am
Nope no triggers. The open table event didn't seem to hit profiler. I suspect that SP1 messed up the client tools and the management console. Since SP1 I can no longer edit job steps that call SSIS packages and get a client side missing component error.
Am looking for a time window to remove and re-install.
thanks for all the ideas gang!
Skål - jh
October 17, 2006 at 9:51 am
I had to un-install all SQL client tools.
Run repairs on the management console.
And then re-install the client tools. Restarting after each step. That seems to have fixed the issue. SP1 is still my prime suspect in this.
thanks all for the help!
Skål - jh
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply