GO
GRANT ALTER TRACE TO username;
GO
If the permission needs to be revoked, use the code below:
USE master
GO
DENY ALTER TRACE TO username;
GO
]]>
GO
GRANT ALTER TRACE TO username;
GO
If the permission needs to be revoked, use the code below:
USE master
GO
DENY ALTER TRACE TO username;
GO
]]>