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 |
|
Meltdown
Starting Member
37 Posts |
 Posted - 2008-11-22 : 17:46:19
|
| Hi all,I created a Finance role in my database and added myself to the role, but when I run select Is_member('Finance') it always come back as a 0 when it should be 1, I've checked that I'm running the query against the correct database. I've checked the database and I'm there in the Finance role.I am the sysadmin as well if that has anything to do with it.Anyone know what the problem might be?RegardsMelt |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-11-22 : 18:36:09
|
| sysadmin has rights to do everything - doesn't gain from role membership.If you look you will be dbo in the database rather than the user you have added to the role.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Is_Member Not Working