开发者社区> 天飞> 正文
阿里云
为了无法计算的价值
打开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.

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

相关文章
SCVMM和SQL分别建在不同服务器上报错:Error ID 319 during database creation on remote SQL Server
问题发生了,测试过权限,帐号,服务,工具问题,均不是。 在微软网站找到解决办法。 就是MASTER.SQL的脚本在数据库服务器上单独运行。 然后,安装SCVMM时,不新建数据库,直接指现建好的库。
549 0
How to recover deleted data from SQL Server
原文http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/ October 22, 2011 by Muhammad Imran In all my years of ...
958 0
SQLServer2000错误解决(Server: Msg 446, Level 16, State
当SQLSERVER2000发生下面错误时,Msg 446, Level 16, State 9, Server CTSSERV, Line 1 Cannot resolve collation conflict for equal to operation(中文:  无法解决   equal   to   操作的排序规则冲突。
338 0
MS SQL Could not obtain information about Windows NT group/user 'domain\login', error code 0x5. [SQLSTATE 42000] (Error 15404)
最近碰到一个有趣的错误:海外的一台数据库服务器上某些作业偶尔会报错,报错信息如下所示: ---------------------------------------------------------------------------------------------------------...
801 0
MS SQL 错误:The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "test" was unable to begin a distributed transact
一同事在测试服务器(系统:Windows 2008 R2 Standard 数据库:SQL SERVER 2008 R2)通过链接服务器test使用分布式事务测试时出错,出错信息如下: set xact_abort on begin tran update test.
975 0
SQL Server 2005 sp_send_dbmail出现Internal error at FormatRowset (Reason: Not enough storage is available to complete this operation)
案例环境:   操作系统: Windows 2003 SE 32bit(SP2) 数据库版本:Microsoft SQL Server 2005 - 9.00.5069.00 (Intel X86)             Aug 22 2012 16:01:52           ...
975 0
+关注
天飞
一个运维老同志
文章
问答
文章排行榜
最热
最新
相关电子书
更多
SQL Server 2017
立即下载
MongoShake -- Multi Active-Active and Cross-Region Disaster Recoverable MongoDB Service
立即下载
Borgaonkar-New-Adventures-In-Spying-3G-And-4G-Users-Locate-Track-And-Monitor
立即下载