Before using the Create User script I was doing the below and it didn't help so I was using the create user script.

-- Create Login

IF EXISTS(SELECT 1 FROM sys.server_principals ...

Thank you Jon. I will see how I can fix the orphan records.

If fixing onetime will take care for the rest of the times then may be I will try...

Thank you Lowell for the information.

And also to let you know, for the first time when the Database was refreshed I manually added couple of users and gave them read...

thank you for the response Jeff.

I have tried earlier with \r\ n and . I think just before I posted the question I changed it to \r to test...

thank you for the advice, I will post might want to start a new thread , how ever it is related to the same issue. I am trying to ignore...

Help needed please

I am trying to run below query fro bulk insert

SELECT MATNR,CASE WHEN ERSDA='00000000' THEN NULL ELSE CONVERT(datetime, ERSDA, 102) END AS ERSDA,ERNAM, CASE WHEN LAEDA='00000000'...