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...

.. can anyone help me with the syntax?

awesome thanks andrew!

Thanks Craig!

Thanks Grant ....that did it!!!

THANKS TO EVERYONE THAT HELPED ON THIS THREAD!!

Good karma to you all..

If any of you are in s.florida ...I'll buy you a beer....or two..