Thanks for the replies. Backups are on a rigorous schedule, and I've done one or two restores in a test DB. Our Test database server is also used by a...
There isn't a way to dynamically grab the product IDs as they are just added sequentially with other product IDs that aren't relevant to my process. So a table does...
For me this happened when I installed SSMS 2017 on my machine using VS 2010 to build SSIS packages for a SQL 2012 server. I believe the issue came out...