Thanks for the article.

I have had the opportunity to work in the three types of environments described.

1. 1 account with admin access to Database servers

2. No admin access to database servers...

The ability to have multiple mirrors, or a waterfall mirror setup would be great. I think you stated it accurately that the setup becomes much more complicated to support...

Thank you for taking the time to put this article together. I will look back in on the article over the next few months as I delve more into...

The query certainly works for 100. For large result sets you would want to consider a different method.

Elliott W (11/16/2009)

---

So let me see if I got you right..

Your boss has you using software outside of the license, ie you don't have a license to use it commercially...

Thank you wikipedia. Whatever politically correct term we want to use - how...

Paul White (2/23/2010)

---

john.arnott (2/23/2010)

---

I know I must be one. My thought on seeing the 12000 mark go by was "less than 300 till the...

Steve Jones - Editor (2/23/2010)

---

Most sources we use are paid for. There isn't a lot in the public domain. Posting a short excerpt from a book is no different than...

Paul White (2/23/2010)

---

I was drinking Coca-Cola when I read that.

I now have a fizzing sensation in my nasal...

nice question. Thanks

Lynn has an additional cross join thus supports up into the billions.

I adjusted my solution to support this

Declare @LimitBigInt

Set @Limit = 150000000

;

WITH Nbrs_2( n ) AS (select 1 union all

select...

Check your email.;-)

Missed another one - it always approaches a milestone when I have to get on the road - dang it.

If it is for pork chops then I am in 😉