surprisingly, couldn't find anything about granting alter trace permissions to a domain account.
I try to run following sql:
GRANT ALTERTRACE TO MyDomain\User1;
GO
And get the following error when executing:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '\'.
What is correct SQL to grant alter trace permissions to a domain account?
TIA.
You must enclose the name between brackets:
GRANT ALTER TRACE TO [MyDomain\User1];
Thanks
Laurentiu
No comments:
Post a Comment