SQL Server has a built-in extended stored procedure, named sp_sdidebug, the permission to which is necessary for a user to have the capability of debugging stored procedures.

To grant the permission, use the following T-SQL statement: (Remark: before you run this statement, you should make sure that you are using an account which has administrator privileges.)
     
 

    USE master
     
GRANT EXECUTE
     
ON sp_sdidebug
     
TO username
posted on 2004-08-03 19:19  Laser.NET  阅读(735)  评论(0编辑  收藏  举报
无觅相关文章插件,快速提升流量