March 12, 2003 at 10:17 pm
I converted a sql 6.5 database to 2k format without any problems -- except one.
The Public role in the new sql2k database shows User "\AlicW", with the "\". That user doesn't exist on the sql2k server but does exist in the sql6.5 DB. I used "sp_dropuser"
but was told the user didn't exist in the sql2k database. How can I delete the user from that role?
TIA,
Bill
March 12, 2003 at 10:28 pm
I believe sp_droprolemember is what you are looking for in this instance.
Tim C.
//Will write code for food
Tim C //Will code for food
March 13, 2003 at 9:37 am
When I ran "sp_droprolemember" in sql2k,
sp_droprolemember 'public', '\Alic'
I got the error : "Msg 15081. Membership of the public role cannot be changed."
Bill
quote:
I believe sp_droprolemember is what you are looking for in this instance.Tim C.
//Will write code for food
March 13, 2003 at 12:48 pm
K, gonna have to see if the forum gurus can answer this one now. I am stumped.
Tim C.
//Will write code for food
Tim C //Will code for food
March 13, 2003 at 2:53 pm
You may try to delete it from sysusers table directly.
The public role is a special database role to which every database user belongs to the role by default.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply