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...