question

rasika_nana avatar image
rasika_nana asked

The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource, schema 'sys'. (Microsoft SQL Server, Error: 229'"

The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource, schema 'sys'. (Microsoft SQL Server, Error: 229'"

I got the above error when trying to expand the tables. If you have solution please post it.

sql-server-2005security
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Gregor avatar image
Gregor answered

SELECT permission was denied is probably the biggest hint. Check the permissions for the user account you are using to log into the SQL Server.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

LeslieM avatar image
LeslieM answered
Make sure you did not enable db_denydatareader
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.