There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
problem when scripting sps with permissions
When scripting multiple stored procedures (would like be able to use it as a promotion script), into one script,
the "grant" statement is not separated by "go" from the script of the stored procedure itself.
That puts the grant statement into the SP itself...