found one..thanks anyway..

-This script will script the role members for all roles on the database.

--This is useful for scripting permissions in a development environment before refreshing

...

Kinda figured....

Thanks Gail

I'm creating only the DB mapping, the user is still there.

the mapping to the dbis what goes away

oh wait that's not gonna work that user already exists....

got it myself thanks anyway...

CREATE LOGIN [UserA] WITH PASSWORD=N'UserA',

DEFAULT_DATABASE=[OrphanedUsers],

CHECK_EXPIRATION=OFF,

...

yep they sure did

I think I have it setup

thanks for your help

I'm not sure of it's origin...pretty sure these are crystal report files.

...wish it was grand theft auto...lol

Okay thanks guys

yep

dba_users is not a table...?

I would use the backup/restore method...less risky...no chance of the file not re-attaching.

dba_users?

Thanks Steve...I ended up changing the source data type. It was incorrect/inconsistant with the other tables.

Thanks again for your help. Happy holidaze..

lol...awesome thanks craig!

I get an error:

Msg 8115, Level 16, State 2, Line 2

Arithmetic overflow error converting expression to data type int.

Msg 245, Level 16, State 1, Line 4

Conversion failed when converting the...