Newbie question - error when accessing tables in sql server management studio express

Hello,

Am pretty new to all that is sql server. I can connect to my sql database using management studio express, but when i try to expand the tables on my db, i get the following error:




TITLE: Microsoft SQL Server Management Studio Express


------------------------------


Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


------------------------------


ADDITIONAL INFORMATION:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)


------------------------------


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


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476


Whats going wrong ???


Thanks Ian

 

Just found out that my permissions were set wrong when the database was setup. Sorted now.