I have found the Output clause to be very handy, great question.

sandippani (2/1/2012)

---

According to me you all are right . I posted this question with 4 options i.e. 1,2,3 and 5. The option 4 was not added by me. The site...

Nice straightforward question, thanks.

I always declare the length so I wasn't sure what the defaults were but assumed that was what the question was about.

Good question.

So I guess that before I get to 15,990,985,574,732,742 pages...

For some reason I thought the question was about database scoped triggers even though it clearly says server scoped. Brain not fully engaged yet. Good question.

The word 'Always' should have made me think twice, but alas I only thought once.

Good question. This is useful.

Yes, me too. Sometimes it pays...

This is a good lesson. Microsoft's warnings about the use of approximate data types have been known to trip some of us up on occasion.

Yes I agree, an interesting question and great explanations, thanks.

Good straight forward question, thanks.

Great question, thanks.

Good question. Probably bound by the number of drive letters available.

Interesting behavior. Thanks for the question Ron.