SQL
Sunday, October 5, 2014
Run SQL Profiler without Sysadmin permission
many times, developers ask permission to run SQL Profiler/Trace. you can grant below permission to run SQL Trace/ Profiler
USE [MASTER]
GO;
GRANT SHOWPLAN to [AD\User]
GRANT VIEW SERVER STATE to [AD\User]
GRANT ALTER TRACE to [AD\User]
Newer Post
Home