Encryption

Using authenticators with SQL Server encryption

  • Article

Authenticators are additional data that gets encrypted along with the data to be stored in an encrypted manner. When it comes to decrypt the data, if the right authenticator isn't specified, SQL Server doesn't return the data in the decrypted form. Rather, a NULL value is returned, just as if the wrong key was used.

2009-06-12

2,384 reads

Blogs

Daily Coping 21 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions

By

I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Read the latest Blogs

Forums

Insert Trigger

By Barcelona10

Hi All, I have table A that has 2 columns(col 1,col2). I would like...

Searching for orphaned DB files on the SQL server

By martin.tydor@gmail.com

Comments posted to this topic are about the item Searching for orphaned DB files...

DEA

By ramyours2003

What is the use of DEA tool in sql ?  how can we  install...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers