Database Administration & Monitoring
SQL Server 2016: Does Dynamic Data Masking works with INSERT INTO and SELECT INTO commands?
21.03.2017 by Stéphane Haby
I wonder how works Dynamic Data Masking (DDM) with these two commands INSERT INTO and SELECT INTO. First, I create a table and add some “sensitive data”: USE [DDM_TEST] GO CREATE TABLE [dbo].[Confidential]( [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY(…)