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.