Error 229: Permissions problem with sysobjects and sysindexes

Hi,

I'm trying to view a database using Enterprise Manager and am getting the
following error when I try to view the list of tables, stored procs etc:

Error 229: SELECT permission denied on object 'sysobjects', database
'tours180805', owner 'dbo'.
SELECT permission denied on object 'sysindexes', database 'tours180805',
owner 'dbo'.

I'm not actually the administrator of this database, and all I know is that
it's a snapshot of a live database setup for me to develop against while i'm
writing a B2B link. As such I don't know what method was used to make the
copy, and if anything has been left out during copying. I don't have these
problems when viewing the live version.

Any help gratefully received.

Ben Fidge


.

Relevant Pages
Loading