I really appreciate both responses.  The logins to a table is an interesting approach.  I would like to hear more about how you go from a table to creating the...

Thanks everyone.

This discussion really helps.  Originally, I mentioned that we could change the datatype to varbinary and have the web application use a convert function to insert the...

Thanks Gail.

But the column is varchar and the manager doesn't want to change that.  The stored proc could get an encrypted value, but how would I directly place...

Management didn't want to add another column.  They asked me if I would have a stored procedure handle this.  My thought is handle what?  

The stored proc or...

The import process when you import data tier application creates a package, create a database and then does the import.

However, running sp_configure worked.  I was able to migrate all...

Well, it looks like I did a good job.  It works!

I ran some tests and it seems like everything is doing well.  I was thinking I had to...

I have 13 rows all full of null values.

LOL!  Now, I am really confused.

This discussion has been more helpful than me creating some quick solution over the weekend.

1.  The warehouse supervisors / managers running a report throughout the day will not...

Good questions and I appreciate them.

I am building a data warehouse that will have aggregated data.  That I would think can be upload once a day.
Then there...

Wow, I didn't think this would be so challenging.

I did the backup and restore the database onto the secondary.
I was finally able to do a transaction log...

I did check the ports with telnet to port 5022.

I actually added a rule to allow incoming traffic for ports 1433,1434 and 5022 on both servers.

Thank you for that.  I have not looked at that type solution.  But I will take a look at that method.

The production lines are going all day.  The...

I actually saw another that made it look like linked servers would be deprecated.  However, it may have just been referring to remote servers.

Thanks for the clarification.

Tony