That green code is sure hard to read, Lowell...

Like I said... just run BCP from the server pointing at the client using UNCs.

Heh... Gail, I'd love it if you could work for us... I'm just not the one doing the hiring.

Trust me on this, though... we have to constantly hit our developers...

Concur... mouse movements at 2AM are much more harmful to the mind than the body... I'd really like to see an article about being in the expert in the hot...

A bit disappointed in the commercialism used in the article... while the tool is powerful, it does not teach how to write SQL fast... and writing SQL fast is normally...

This isn't Oracle... stop using cursors.

Any feedback, Stephen?

Like Remi says... why use a cursor???

 UPDATE TABLE_1

    SET Rnd = RAND(CAST(NEWID() AS VARBINARY)) * 10000000000000

Any feedback, Anders?

Amrita?

I just love it when the OP doesn't respond... stab'n'grab.

There are a number of ways to returns trees in a high speed fashion in SQL Server 2000.... are you simply having performance problems or are you just concerned with...

Concur...

It's just a gut feeling but your "need" is nothing more than a "feeling"... Hilton clients will understand that it's all the same company and they won't worry about ID...

Sorry for being a year late.

I thought the title of this article was "Sizing a Database"... not an advertisement for some 3rd party software.

Heh... I don't know and I'm sorry about that.  I don't have 2l5, yet.