SQL Server : cannot execute sp_enable_sql_debug -
i have been using sql server management studio on year on computer , today login database usual , run query , error appears:
the execute permission denied on object 'sp_enable_sql_debug', database 'msmsqlsystemresource', schema 'sys'. error:29
upon google says grant permission stored procedure like:
grant execute on sys.dbo.sp_enable_sql_debug 'me' the me database login
when run grant statement, same error message. seems cannot grant permissions?
can help here?
there no dbo in grant statement. have add together user master grant work.
sql sql-server sql-server-2008
No comments:
Post a Comment