This is the exact text

CHECKDB found 2 allocation errors and 2 consistency errors in table 'ALLOCATION' (object ID 99).

The repair level on...

It does. Thanks!

Had to end up restoring 🙁 but thanks.

Is there anyway to just test the operator(s)?

Great! Thanks!

Were you able to get this to work? or find an alternative solution?

Awesome! Thanks for the fast response!

Good idea.

Thanks!

Alright. Thank you so much for all of your help.

Correct. As many times as I do a select top on the original, it is always the same. When I do the same on the new table, it is not...

No indexes at all on the table. It is just a plain old heap table. If it were up to me, I add an index or PK on it, unfortunately...

I resolved this by adding the sql server 2000 client to the server. the 2000 client does not work, but the MOD Error is gone and now works.

It is a 64 bit server and SQL Mail is not available for this. Makes sense.

SQL Service and Mail are using a domain account. Database mail is now working, but we still need sql mail as well. Same error as above.

How do I do that? with the udf? there is no way I can create it via a user defined datatype?