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?

Try this :

Select A.Key1, A.Key2, A.Key3, B.Key1, B.Key2, B.Key3 FROM BaseTable A INNER JOIN OtherTable B ON A.Key1 = B.Key1, A.Key2 = B.Key2, A.Key3 = B.Key3

Forgot to mention that it's gonna be an excellent refference for nulls from now on .

You either have an error in the Column or in the script.  A not null column will NEVER allow a null to be inserted.

Want to See Something Weird?

Now that...