Hi all,

I'm trying to transfer objects and data between SQL Server 7.0
databases, but it always fails with message stating that it can not find
certain user or group while I've checked transfer database users and
database roles option.

Any help would be greatly appreciated.

Thanks in advance


Setya



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I personally never use this task but is the error when trying to apply the
logins on the destination ?
Is this a 2 server transfer ? If no then you do not need to move logins.
Is it failing on a given user i.e. a local user that simply cannot be there
at the destination (2 server)?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Setya Nugraha Djajadinata" <jsetya (AT) yahoo (DOT) com> wrote

Thanks for the response,

I moved object and data within the same server and I successfully
performed the task after I deleted users from the source DB. Those users
belongs to public standard role but strangely I can not find them in the
Users node. Any ideas?

Setya


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Not sure I understand.

You have removed users from the Source DB ?
When you specify "Copy database users and roles" it doesn't work ?
The error is "Cannot find user" ?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Setya Nugraha Djajadinata" <jsetya (AT) yahoo (DOT) com> wrote

I mean, there are some users in the source DB that belongs to public
role, but I can not find those users in the users node. I have to remove
these users first (except dbo) to successfully copy data and objects to
other DB.

Setya



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

What happens if you do

SELECT * from sysusers in your Source database. Do they appear in there

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Setya Nugraha Djajadinata" <jsetya (AT) yahoo (DOT) com> wrote

I've tried your query and it does not show those users but when I double
click the public role those users are listed under standard role and you
have to remove them first using sp_dropuser before you can transfer the
data and objects.

Setya



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

All users in a DB should be located (Except sysadmin) in the sysusers table
in the DB in Question.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Setya Nugraha Djajadinata" <jsetya (AT) yahoo (DOT) com> wrote

I see, thank you very much for your response so far.

Setya



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!