Use two views. One for CRUD, one for display that decrypts data.

What's the purpose of the view? In other words, what are you trying to accomplish?

If you use decryptbykey() in the view, you can't insert data into that...

Replication can work. export/import can work, whether you use SSIS or something else. Keep in mind, your web service essentially does this, by querying a database, getting results, putting in...

Interesting. Are you working only with calendar days? So a Friday 4:00pm ticket open until Tues 9:00am after a weekend and Monday holiday is 480 (Fri) + 540 (Tue) minutes?

You still need the key open, so anyone that can't open the key will get NULLs in the view.

You'll have to provide more information. How is the insert working, how do you test an exception? Is this through some process?

Tooling definitely matters, though whether this is bespoke (custom) tooling, or purchased tooling is up to you. There are good OSS packages for some things, some good commercial products for...

Thanks, Konstantin. Added.

It's not. Was one I learned something from while researching.

That is bad.

The discussions are the best part

Sorry, that was just an example, and I was thinking one thing and writing the other. This was an article on trace flag changes, not the specifics of what an...