Incorrect syntax near 'masked'

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  December 7, 2015 at 8:00 am

  #313732

  Hi friends,

  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.

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  December 7, 2015 at 8:20 am

  #1844400

  Hey folks I found the solutions for this -

  For version SQL Server 2016 CTP 3 we do not need to run DBCC TRACEON (209,219,-1) else it will show the error.

  For version earlier than CTP 2.1 we need to enable the trace flags.

  So, when I run the command DBCC TRACEOFF(209,219,-1) and then run my alter statement it worked.

  Thanks all 🙂

  Hope it will help others

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/