Last post May 09, 2019 09:41 AM by PatriceSc
May 09, 2019 06:28 AMfirstname.lastname@example.org|LINK
I have a column in the SQL Server 2005 DB which needs to be masked to ****. I tried masking it using mask function, however I found out that masking function works only in SQL Server 2016 + and above.
Is there any easiest way to alter an existing column in SQL Server 2005 DB to ***** ??
Looking forward to hear from you. Thanks.
May 09, 2019 09:41 AM|PatriceSc|LINK
You could use a view instead rather than exposing the real table. The purpose is to hide this from users having direct access to the database ? In this case a general purpose SQL Server at
https://social.msdn.microsoft.com/Forums/sqlserver/en-us/home?category=sqlserver could be better.