A personal repository of random information in compensation for a fatigued biological computer
Breaded IT » MS Access / SQL Server reminders » SQL Server 2008: could not read metadata
sql server 2008: Right click DB -> Script as create = could not read metadata possibly due to insufficient access rights
http://www.sqlservercentral.com/Forums/Topic355850-149-1.aspx
From SSMS
Right click on the server name and click properties
Click on the Permissions tab
Click the user name
On the Explicit Permissions almost at the bottom there is "View Any Definition" grant that. See if that will work.
That should do it for any database, there is a very similar functionality for each database as well.