May 27, 2009 at 11:45 am
Hi...We just had restored a database into SQL Server 2008...In the database, under tables I can't see any tables listed out there...but in object explorer details I can see all the tables and I can query the tables as well..but why I m not able to see the tables?? is there any security setting for this??
Thanks a lot...
May 27, 2009 at 11:52 am
Refresh maybe? Restart SSMS?
May 27, 2009 at 12:08 pm
Thanks for the quick reply....
do we have to Restart the SQL Server??? I just refreshed, disconnected and reconnected to the server...none of the developers or DBA can see the tables!!!! I never restarted the service...
May 27, 2009 at 12:11 pm
View Any Definition permissions?
A.J.
DBA with an attitude
May 27, 2009 at 12:15 pm
I didn't get that....
But, Directly If I login to the server i couldn't see the tables....If I connect to that server from my local SSMS, I can see the tables...its weird...
May 27, 2009 at 12:24 pm
Are you connecting both ways using the same login or NT login credentials?
A.J.
DBA with an attitude
May 27, 2009 at 12:27 pm
I logged in as both sa login and Windows...I can't see them either...
Thank you
May 27, 2009 at 12:34 pm
That is certainly odd, and when you close SSMS and reopen it, it still fails? If so, I would be reinstalling the client tools myself. Is this true on all databases (msdb, master, etc) or just the one you restored?
A.J.
DBA with an attitude
May 27, 2009 at 12:37 pm
I think you are either connecting to a different instance or database if you can see them from one place and not another with the same credentials.
When you log in, no matter if you are running SSMS from the server or workstation, you are always connecting the same way,a remote connection, to the instance. If the credentials work in one place, they work in the other.
Permissions are the same.
I would slow down and double check the instance you are connecting to in each case.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply