What is it you need to do exactly??

Well actually everything gets updated to 'N'.

You don't need the exists clause here, just use a left join to make this update >>

UPDATE A Set A.col_1 = CASE WHEN B.col_1...

Search on this site or the web... quite easy to find.

Here's the script version :

alter dbo.TableName

add ColumnName int not null identity(1,1)

GO

much simpler... and can be reran whenever needed.

Oh, can't help you there... .

You shouldn't get errors if you add a primary key.

You can always import the data, then add the PK...

Just go with the with encryption.

Make sure that you have backups of the code cause you won't be able to access it again.

However I must tell you that there are...

No real hurry here... Gonna have to hurry if I don't want to miss the week-end .

...Been told that for 15 years...

Time will tell.

Post the code. You are not using the insert/deleted tables correctly and probabely using variables when you shouldn't.

Don't know how to change it but it can make a difference if there's too much noise on the network.

Not even for the first time .

I'm not the kind to fall for that .

So you're afraid of girls, how is it you are married??

Is this a one time task or an import job?