all groups > sql server dts > march 2004 >
You're in the

sql server dts

group:

sql dts error no such user or group


sql dts error no such user or group Mike
3/20/2004 10:37:29 PM
sql server dts:
I'm trying to copy tables and stored procedures from a
hosting provider. It seems to work for the most part,
but I receive this error:

There is no such user or group 'name'

Does anyone know what this error means? It seemed to
Re: sql dts error no such user or group Allan Mitchell
3/21/2004 10:17:28 AM
It may be that you are trying to copy users as well and they cannot be
applied locally simply because their names canot be resolved. Remove the
option to move these in the task.

--

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


[quoted text, click to view]

RE: sql dts error no such user or group Mike
3/21/2004 5:41:53 PM
Simply overlooked, that was it, thanks!!!


[quoted text, click to view]
RE: sql dts error no such user or group rboyd NO[at]SPAM onlinemicrosoft.com
3/22/2004 1:15:16 AM
There is probably a table that is owned by a user that is not in the
destination database. Check the owners of the tables ins the source
database and verify that no tables are owned by users that are not in the
destination database.

Rand
This posting is provided "as is" with no warranties and confers no rights.
AddThis Social Bookmark Button