I just downloaded Toad For SQL Server on to my server and created a new account/user on SQL Server to work with.
But when I try to trace sessions, I get permission denied.
I have given it the following:
GRANT ALTER TRACE TO xxxxx;
GRANT SELECT ON SYS.TRACES TO xxxxx;
what else is required so I can conduct a session trace?