In Object Explorer, connect to an instance of Database Engine and then expand that instance.Įxpand Databases, expand the database in which the procedure belongs, and then expand Programmability.Įxpand Stored Procedures, right-click the procedure and then click View Dependencies. To view the dependencies of a procedure in Object Explorer
#To view stored procedure in aqua data studio how to#
How to View the Dependencies of a Stored Procedure When SELECT and VIEW DEFINITION permissions are granted to another user, the grantee can view all dependencies in the database. By default, SELECT permission is granted only to members of the db_owner fixed database role. Requires VIEW DEFINITION permission on the database and SELECT permission on sys.sql_expression_dependencies for the database.
Object Catalog View: sys.sql_expression_dependencies Requires VIEW ANY DEFINITION permission on the server when the referencing entity is a server-level DDL trigger. Requires VIEW DEFINITION permission on the database or ALTER DATABASE DDL TRIGGER permission on the database when the referencing entity is a database-level DDL trigger. By default, SELECT permission is granted to public. Requires SELECT permission on sys.dm_sql_referenced_entities and VIEW DEFINITION permission on the referencing entity. System Function: sys.dm_sql_referenced_entities When the referenced entity is a partition function, CONTROL permission on the database is required. Requires CONTROL permission on the referenced entity and SELECT permission on sys.dm_sql_referencing_entities. System Function: sys.dm_sql_referencing_entities To view the dependencies of a procedure, using: SQL Server Management Studio, Transact-SQLīefore You Begin Limitations and Restrictions Security Permissions This topic describes how to view stored procedure dependencies in SQL Server by using SQL Server Management Studio or Transact-SQL.īefore you begin: Limitations and Restrictions, Security
0 kommentar(er)
