I wasn't able to create the index.

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.TableID' and the index name 'ClusteredIndex-20180604-101725'.

I can't create the clustered index with the duplicates. I've already tried that.  I have get rid of the dups first.

I guess I could write a query to...

Lynn, sorry to let you down.  I did look at the url, but I definitely missed the colons.

Scott, Thank you, thank you and again thank you.

I...

I do appreciate the thoughts and ideas.  But I checked and no triggers.  Can't remember when I was stomped by an update statement.🙂

Removing the dashes didn't seem to resolve it.  Got the same error message.

This is working with SQL Server 2016.

Thanks.  I downloaded it and am taking a look at it.

Jeff,

What is your thought on changing the data?  I am not sure I follow you with changing the data.  This data masking obfuscation is just for refreshing the...

Steve,

Yes, I saw a demo of that product.  That is why I was asking if the Dynamic masking did that.

When they say they need the birthdate,...

Thank you.  I didn't see any examples that could add two months onto the birthday by using the Data Masking.  I also didn't see any way to display a masked...

You were exactly right.  I hate the time I spent reading blogs to resolve that issue.

Yes, I disabled the log backup job and the wizard was able to...

Sue,

You have the right of it.

I am very adept at scripting in SQL Server.  However, I normally only use scripting for backups when I want to...

That was my thought also, but I wanted to put the question out just in case.

I had norecovery for full backup restore as well as the log files...

That sounds awesome.

So you put in output into a column?  What datatype?  Varchar(max) I would assume.
Then you add that row to a "DBA" database that is synchronized?