This is exactly why I love this site. I was getting the same error from copying a query from QA to my DTS package. Placed these two commands at the...

The reason I need to reassign bar codes is it's what the customer wants. It is a school district who is assigning barcodes to students and they don't want the...

Thanks Lowell and Jeff. Sorry for not getting back sooner but it's been hectic around here! Jeff your routine works perfectly at finding the gaps in the barcode sequences. I...

I had the same problem with conflict tables. Here is a script that worked for me:

-- Script to drop all conflict tables

-- in the database

-- This script MUST be...