Agreed on both the addition you made for the bullet proofing and, considering the situation, going incognito.  Heh... I dare not go incognito... it would remove some self-imposed limits and...

If you DO actually have 100's of servers you need to do this to, then you actually do need some help because if you do actually land or build...

I guess I don't understand why anyone would write software based on the knowledge of novices.  If it's important for a novice to be able to maintain something...

I don't understand why anyone would use a CLR function for such a thing to begin with.  Is the CLR getting the ISO data from some URL or what?

Hi Jeff

So you can do this across different sql versions because we are migrating / upgrading from sql  server 2012 (production) to sql server 2016 (new server)?

you can apply...

Here's the way I've done such a thing many times now...

1. Obviously, prep the new box with all that's necessary including DB settings, logins, linked servers, etc, etc.
2. As the...

Heh... I love it!  No PoSh required, either.

I agree that sys.objects is a good source for the brunt of what you're looking for.  Unfortunately, it doesn't cover everything.  For example, indexes, statistics, and partitions aren't covered by...

You're spot-on I think. Paging (or other remote options, sorting, filtering. etc.), however it's accomplished, should not be used without consideration for the issues it brings (especially potential inconsistency,...

Jeff -

There are other options out there.  Databases that use multi-version read consistency do exactly what you are asking - present an accurate picture of the state of data...

I know this sounds obvious, so apologies if it is for whomever reads this.  I just wanted to say it out loud if it's not obvious...

This reminds me of a...

I love that...

Our problem is that our ERP is ancient, there is no primary key between the sales header and line tables, there is no timestamp on the sales line table,...

I strongly recommend that you upgrade that to the latest and...

I wonder why you specifically mentioned 2017.  It works the same in all versions from 2005 and up.