Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qwertyjjj
Posting Yak Master
131 Posts |
 Posted - 2007-09-27 : 12:57:19
|
| I created a database role but then decided to delete it and just use public instead.I used sp_droprole to delete it on the database.Now when I click through security and to the permissions on the login group I get the error: 15409 {rolename} is not a role.Is this because I need to drop it from the master db as well? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 01:01:02
|
| Was the role empty when you deleted it? Don't touch master db if you didn't create role there. |
 |
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2007-09-28 : 05:38:10
|
| I think so yes as it wouldn't let me delete it until I removed the members. |
|
|
|
|
|
|
15409 name is not a role