As currently we dont have any category to discuss SQL Server 2016 problems so I am posting it here.
I was exploring data masking feature of SQL server 2016 CPT3 version.
But Whenever I tried to add masking to any column it gives me error: Incorrect syntax near 'masked'
Here is the syntax that I have written-
ALTER TABLE Demo_Masking
ALTER COLUMN Salary ADD MASKED WITH (FUNCTION = 'random(1000,90000)');
I have enabled the trace flags 209,219 for data masking. But still I am getting this error.
Can anyone help me on this.