{"id":121,"date":"2009-08-13T09:47:50","date_gmt":"2009-08-13T14:47:50","guid":{"rendered":"\/\/www.beauchamp.me\/techno\/?p=121"},"modified":"2009-08-13T09:48:31","modified_gmt":"2009-08-13T14:48:31","slug":"sql-server-profiler-and-alter-trace-permission","status":"publish","type":"post","link":"https:\/\/www.beauchamp.me\/techno\/blog\/2009\/08\/13\/sql-server-profiler-and-alter-trace-permission\/","title":{"rendered":"SQL Server Profiler and ALTER TRACE permission"},"content":{"rendered":"<p>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:<\/p>\n<blockquote><p>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.<\/p><\/blockquote>\n<p>In order to resolve this, you need to issue the following SLQ query in the master database:<\/p>\n<blockquote style=\"text-align: left;\"><p>GRANT ALTER TRACE TO <em>username<\/em><\/p><\/blockquote>\n<p>Replace <em>username<\/em> by the username you want to use to access the database in SQL Server Profiler.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","category-sql-server-2005"],"_links":{"self":[{"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/posts\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/comments?post=121"}],"version-history":[{"count":3,"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":124,"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/posts\/121\/revisions\/124"}],"wp:attachment":[{"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/categories?post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beauchamp.me\/techno\/wp-json\/wp\/v2\/tags?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}