I got this error when I attempted to view the tables of a database in MSSQL Server Management Studio Express 2008:
The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
The way out: At the server, I double-clicked on my login at Security > Logins and then went to Server Roles where I added sysadmin
No comments:
Post a Comment