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]
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)