Thanks again Steve, that's great information. I don't have access to that link, how can I get it?

Thanks again for being so responsive and helpful!

Thanks so much Steve for your quick response!  It's actually hosted in a private vendor for now, but will move to an Azure VM. TDE encryption isn't an option currently...

This is a great article, and an excellent way of outlining the process.

Given a cloud-based application, do you know if it's at all possible to encrypt data (whether in a...

Like a number of previous posters said, @@IDENTITY is not a good thing to use...

I normally use ident_current. Here's an example...

CREATE TABLE Temp1 (ID int IDENTITY(1,1) NOT NULL, someChar Varchar(4)...