To expand on the reason I'm not using other DDL scripting methods is because I'm looping through hundreds of tables and running tests on converting data types and changing data...

Changing it to select provided all of the characters. Now I need to figure out an easy way to copy those results since it loops over hundreds of tables all...

When you say use select instead of print are you saying to toggle results to text and then use select @SQL1 which in my case has a string of 11,698...

Phil - that helps limit each printout to 4,000 characters but in my case the string is 11,698 so it breaks it into three separate lines. The script I'm creating...

Phil - Yes, the SQL PRINT output. In particular printing out strings, or concatenating, strings longer than 8,000 characters.

My bad. Apparently I did not submit my post last week thanking Ant-Green for his solution and assuring this is not for SSNs or any kind of PII data. There...

I just had a chance to get back to this and I can tell you it made a huge difference. Thanks, Scott!

Out of those three options, the trigger might be the only one I'm able to use. I'm not a fan of going that route but I'll look into seeing if...

We've done quite a bit of testing and so far so good with no data loss. Let's hope that continues to be the case.

It is Dell Data Domain Boost

Yes, 3226. My bad on the typo.

It is a third party backup which I've looked at their documentation to see if there is a setting to prevent writing to the...

Understood. I wanted to make sure this wasn't part of some bigger issue or something of that nature. Thanks for the help.

That part makes sense. Why does 2016 work differently than previous versions?

Thanks, Cebisa!

1. So it can be automated to happen at a specific time on a specific day
2. My hope is that it can be initiated from the primary node rather than...