Timeline for Assign db_owner to all users at once
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 1, 2016 at 16:37 | vote | accept | QWE | ||
| Jul 18, 2016 at 14:52 | comment | added | Joe Platano | @REvans you are right, I ll fix the code | |
| Jul 18, 2016 at 14:51 | history | edited | Joe Platano | CC BY-SA 3.0 |
added 177 characters in body
|
| Jul 18, 2016 at 14:06 | comment | added | R Evans | That's a workable method. One suggestion though: Since sp_addrolemember operates within the current database. You'll need to make the call to that sproc dynamic as well, adding a USE statement before the stored procedure call. | |
| Jul 17, 2016 at 4:02 | history | answered | Joe Platano | CC BY-SA 3.0 |