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
 Transact-SQL (2005)
 Sysobjects

Author  Topic 

niranjankumark
Posting Yak Master

164 Posts

Posted - 2008-03-20 : 02:37:48
I am not aboe to view the userdefined tables in sql 2005. not sure whether my user dont have permission to view. how to view my user permission or not ..

another one , is there any table to find system table instead sysobjects,information_schema in 2000.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-20 : 02:45:39
Contact your DBA to find out what permissions you have.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-21 : 00:40:27
>> is there any table to find system table instead sysobjects,information_schema in 2000.

No, sysobjects is the only table.
Go to Top of Page
   

- Advertisement -