Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cannot Open Tables Folder

Author  Topic 

bshouman
Starting Member

1 Post

Posted - 2008-08-01 : 04:58:11
Hello,

Im connecting to a remote server successfully, Im opening Database named test also successfully, all the folders in this DB are opening except for Tables folder where im having this error
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

I have SQL2005 SP1, Im connecting with SQL Authentication.
Some colleagues are facing this problem others are not(they are connecting with the same username and password(sa))

Any Ideas

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-01 : 09:22:46
What do you mean by Table Folder?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-02 : 00:01:35
Did you apply sp1 for your client tools?
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-08-02 : 01:19:41
this sounds like an error in SSMS. in the dialog that pops up, you can click some button for more details on the error. in particular, there's one that will show you the callstack. copy that and paste it here. That will have more detailed information about why SMO can't enumerate the tables.


elsasoft.org
Go to Top of Page
   

- Advertisement -