Thursday, June 11, 2015

Viewing DDL in SQL Server

To provide a read only view of the list and content of the DDL elements (procedures, functions etc) in SQL Server without granting ddladmin use

GRANT VIEW DEFINITION ON SCHEMA::dbo TO [domain\user]