If you want to be able to view the schema in a QA or Production instance of SQL 2005, you will need to run the following permission:
GRANT VIEW DEFINITION ON SCHEMA::dbo TO user-account
I have found this extremely useful so I can compare exactly WHAT procedure or function is in the QA/production instance.
Posted
Jul 03 2007, 08:53 AM
by
jsmith