i am trying to assign alter permission to a specific SQL login and have scuerd the internet looking for a solution but had no luck ..
please is there a way to give my sql login alter permission on this stored "extented stored procuderd in master database"
Msg 4606, Level 16, State 1, Line 1
Granted or revoked privilege ALTER is not compatible with object.
I'm probably just confused, but sp_create_trace is not a documented stored procedure. Do you mean sp_trace_create? It requires ALTER TRACE permission.
Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
- Proposed as answer by Mohit K. GuptaMicrosoft employee Tuesday, July 17, 2012 7:29 PM
- Marked as answer by amber zhangModerator Tuesday, July 24, 2012 1:36 AM