I forgot to add that the SQL Server driver on one server is 3.50 and 3.60 on the other. I realize that these are super old and I believe...

Try using exec sp_spaceused 'tbl_TableName'

This returns how many rows and how much space the table takes up and the indices too.

I think they are both basically the same except you can't use set to get data from a table.

SET @Counter = @Counter + 1

SELECT @Counter = COUNT(ID) FROM...

Makes sense. Thanks again. I thought I was going to have to do some sort of hack trigger that converted it to it's CHAR value.

That worked!! Thanks!

Can you explain why it worked? Shouldn't it be SQLINT if it is going to an INTEGER column?

Have you tried sorting the results based on the priority of the two records and then taking the TOP 1. Therefore if the query returns more than one row...