I would also check your default trace that is running. Most default traces automatically capture auto grow events.

If I understand your question correctly, I would start the incremental column on table A at 1 and increment by 2. I would start the incremental column on table...

ISNULL() does only work for NULL fields and does not catch empty strings. Your example should work just fine. I use something similar in a lot of my...

Also, you can use the ISNULL() function.

You should look into using either a case statement or the coalesce function.