Monday, December 26, 2011

sysadmin

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