public role problem

Hi all
I had a database that was copied over from one server to another say SERVER1
to SERVER2. As always it happens that the permissions too get carried over
with the database. I was able to remove the carried over logins from all the
roles but not from public. So now I am not able to create the same login on
SERVER2 as on SERVER1 since it tells me that the login is already existing
in the database as a role.
I do understand that no members can be removed from public.. but is there
someway I can bypass this to create the same logins on SERVER2 as on SERVER1
' Or is there something wrong that I am doing while copying the files..
should I be taking some other precautions when copying over.. '
Any help is appreciated.. Thank you
NEVILLEDropping the login on server level or the user on db level will remove the
membership of the login/user in public.
Have a look at http://support.microsoft.com/view/tn.asp?kb=246133
hth
Quentin
"Neville" <george@.synygy.com> wrote in message
news:uD5lkGT2DHA.2528@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi all
> I had a database that was copied over from one server to another say

---

SERVER1

quote:

---

> to SERVER2. As always it happens that the permissions too get carried over
> with the database. I was able to remove the carried over logins from all

---

the

quote:

---

> roles but not from public. So now I am not able to create the same login

---

on

quote:

---

> SERVER2 as on SERVER1 since it tells me that the login is already existing
> in the database as a role.
> I do understand that no members can be removed from public.. but is there
> someway I can bypass this to create the same logins on SERVER2 as on

---

SERVER1

quote:

---

> ' Or is there something wrong that I am doing while copying the files..
> should I be taking some other precautions when copying over.. '
> Any help is appreciated.. Thank you
> NEVILLE
>

---

|||Sorry for not specifying something that I just noticed.. I do not see the
carried over logins in the users list of the database through Enterprise
Manager.. However, querying the database shows that the users exist.. I
tried refreshing the screen, reconnecting to the server and a lot of other
things but it still does not show me the users through Enterprise manager.
Funny though, one of my colleagues connected to the server from his desktop
with the same login and was able to see all the carried over logins.. which
rounds off to one thing that the problem should be with something on my
desktop.. However, I did not find any settings different from that on his
desktop..
And btw thanks for the help with the link..
NEVILLE
"Quentin Ran" <ab@.who.com> wrote in message
news:eOVpnlT2DHA.3436@.tk2msftngp13.phx.gbl...

quote:

---

> Dropping the login on server level or the user on db level will remove the
> membership of the login/user in public.
> Have a look at http://support.microsoft.com/view/tn.asp?kb=246133
> hth
> Quentin
>
> "Neville" <george@.synygy.com> wrote in message
> news:uD5lkGT2DHA.2528@.TK2MSFTNGP10.phx.gbl...
> SERVER1
over[QUOTE]
> the
> on
existing[QUOTE]
there[QUOTE]
> SERVER1
>

---