Edgar Navasardyan
Reputation: 4511
SQL Server Management Studio - Failed to start debugger (Error 229)
I put a breakpoint somewhere in a stored procedure in SQL Server Management Studio and then press start debugger. I end up getting
Error 229 error (failed to start debugger)
It appears to be a problem with permission, and I tried to ask the DB admin to execute
grant execute on sp_enable_sql_debug to my_login_name
command, but the syntax of the command is erroneous. Any ideas ?
Upvotes: 0
Views: 14368
Answers (1)
Aravindhan R
Reputation: 269
Simple thing to over come this error. Go for sql server db and select security and click on login. In that u can see your login name . Right click on it and click properties . In the left screen u can see the role in that u want check public and sysadmin . Now restart your db and visual studio. Now it work fine and i have clearly explained
Upvotes: 3
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to add a column with a default value to an existing table in SQL Server?
- Check if table exists in SQL Server
- How do I UPDATE from a SELECT in SQL Server?
- Auto increment primary key in SQL Server Management Studio 2012
- How do I escape a single quote in SQL Server?
- How to check if a column exists in a SQL Server table
- How can I do an UPDATE statement with JOIN in SQL Server?
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- How can I delete using INNER JOIN with SQL Server?