Is there any way you can create a new database and export those 2-3 tables there.  Then backup the data and send it to me so I can check it...

Thanx .

"Sooner or later, maybe those countries will outsource their work back to US !!"

I think that it'll be outsourced to Canada first so it looks like I'll be working for...

ACL??

Is that some NTFS permission talk?

can you post the dependant objects (base tables and views) DDL.  That way I'll be able to try to execute this proc.  So far it creates the proc just fine.

Looks like we had the same idea.  However I don't like deleting the folder directly.  So I was hoping for a hidden uninstall feature...

I did check for that but apparently it doesn't work for 2000.  Anyone got a solution for that one?

Damn, forgot to ask for the ddl on the other table.

Are there any differences in datatypes or collations between the 2 tables?

NP... we all like to have and give accurate info.  Let's just hope he'll have time to get it fixed before it goes out the a newsletter.

See for yourself :

DECLARE @X AS VARCHAR(10)

SET @X = 'Test'

IF @X IN ('t', 't2', 'Test')

BEGIN

 SELECT 'Hello world'

END

Have you tried reinstalling the client tools (or the server altogether)?

can you post the full table DDL with constraints and indexes?

Maybe we'll spot something you missed.

We can't see the images... They must be uploaded on a web server to display correctly here.  (check yourself from another pc and you will see what we see).

OR

if @Whatever in ('value1', 'value2')

This is more easily expanded.

Do you have a second unique index on the table or a trigger that inserts into a third table?