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 2000 Forums
 SQL Server Administration (2000)
 Cant view tables created by the user

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-27 : 08:29:06
Mohsin writes "i can not view the tables that are created by the user.. it only shows tables of type system and not of type user...

please reply quickly

Thanks"

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-02-27 : 08:34:24
Are you logged in as yourself? If so, what database roles are you a member of? If you are not a member of any database roles, do you have SELECT rights on the tables?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -