Hey Sqeeps,
I was running an upgrade today and had to jump a major version while upgrade (from 2008R2 to 2019). I know not yet on 2022. It takes time for old joints to move. :)
Well there was a small hiccup that there were a lot of tables in the db and I need to run some sanity check before I could hand over the database to the development team.
So thought of putting together a small cursor which should help anyone with read permissions to run a sanity check on all tables in the databases.
Well that runs like a monster and takes for ever so modified the query to take just 1000 rows from each table.
Hope this helps SQeeps.
Untill Next time,
Cheers,
Tushar
