开发者社区> 天飞> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission.

简介: SQL用PROFILER时产生的权限问题。不用大开到SYSADMIN的权限吧。 用以下方法完美解决。只给TRACE权限。   SQL Server Profiler and ALTER TRACE permission Yesterday, I wanted to use SQL S...
+关注继续查看

SQL用PROFILER时产生的权限问题。不用大开到SYSADMIN的权限吧。

用以下方法完美解决。只给TRACE权限。

 

SQL Server Profiler and ALTER TRACE permission

Yesterday, I wanted to use SQL Server Profiler to check what was happening on the database side of an application I am developping. However, SQL Srever Profiler was giving me the following error message:

In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission.

In order to resolve this, you need to issue the following SLQ query in the master database:

GRANT ALTER TRACE TO username

Replace username by the username you want to use to access the database in SQL Server Profiler.

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
Git报错--Everything up-to-date branch ‘main‘ set up to track ‘origin/main‘.
Git报错--Everything up-to-date branch ‘main‘ set up to track ‘origin/main‘.
6 0
cocopods 命令行执行命令时报错You don't have write permissions for the /Library/*
cocopods 命令行执行命令时报错You don't have write permissions for the /Library/*
1065 0
jsp页面引入css文件报错 javax.servlet cannot be resolved to a type
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/bitree1/article/details/50454142 登陆 可能是jdk 里不包括servlet-api.jar这个包,到tomcat里找到这个包复制到java项目里。
887 0
【oracle官网】 Restoring a Database on a New Host
Restoring a Database on a New Host 本文连接地址:http://docs.oracle.com/cd/E11882_01/backup.
821 0
wamp You don't have permission to access / on this server等问题的解决.
原文: wamp You don't have permission to access / on this server等问题的解决. 安装完wamp之后,安装网上的教程设置虚拟路径,出现了问题,同样的问题由不同的原因导致。
1069 0
HOWTO recover deleted files on an ext3 file system
http://www.xs4all.nl/~carlo17/howto/undelete_ext3.html 
552 0
+关注
天飞
一个运维老同志
文章
问答
文章排行榜
最热
最新
相关电子书
更多
SQL Server 2017
立即下载
Borgaonkar-New-Adventures-In-Spying-3G-And-4G-Users-Locate-Track-And-Monitor
立即下载
MongoShake -- Multi Active-Active and Cross-Region Disaster Recoverable MongoDB Service
立即下载