thanks for the question - cheers

thanks for the question. cheers

in case anyone is interested, here is another link on batches that explains things going on here:

http://msdn.microsoft.com/en-us/library/ms175502(v=sql.105).aspx

Thanks Steve.

+1 for answer #2... FK won't create an index, but I got sucked into the trap overthinking the OTHER CONSTRAINTS.

Thanks for the question Hugo - cheers

Thanks for the question Ron.

jeff.mason (6/25/2012)

---

Here is the problem:

"A Table Variable can have primary keys and indexes defined"

This can be read two ways.

1) "can have defined" can be read to mean "can have the...

tks for the easy question to round out the week and great discussion! cheers

Answered off the cuff believing that FOR ATTACH rebuilds the log.

Thanks tommyh for confirming... Missed the earlier post

Cheers

thanks for the question and interesting discussion - cheers

great question and discussion again today - cheers!

thanks for the question

Thanks for the question - cheers

Great question Hugo. Cheers.

<--- + 1, been there, debated this too....

interesting questions - cheers

thanks for the question - cheers