I already posted a solution without cursors. If you can't get Dave's one to work, use mine.

There are very...

Gail, in this case won't SELECT .. INTO copy the whole table in a single transaction? In that scenario BULK_LOGGED recovery won't help.

As long as it is running, the log...

You could:

A) insert rows one by one (or x by x, you could play with the right batch size), or it will be a single transaction for the whole set...

Dave Ballantyne (7/14/2009)

---

Off the top of my head....

with cteResursive(BaseRecordId,RecordID, ParentRecordID, Credit)

as

(

Select RecordId,RecordId,ParentRecordId,Credit

from yourTab

where ParentRecordId...

This is one way to get it:

DECLARE @test-2 TABLE (

RecordID int,

ParentRecordId int,

Credit int

)

INSERT INTO @test-2 VALUES (1, NULL, 10)

INSERT INTO @test-2 VALUES (2, NULL, 5)

INSERT INTO @test-2 VALUES...

Oops! It was snake instead!

http://en.wikipedia.org/wiki/Snake_(video_game)

Gorilla was quite easy to play even if it ran too fast.

Link for nostalgic folks:

http://en.wikipedia.org/wiki/Gorillas_(video_game)

GilaMonster (7/14/2009)

---

Yeah, it was. That was part (maybe too subtle) of my joke. It could...

Don't know the whole thing, but I can throw in a hint fo a further search: kerberos tickets expiry?

Hi Graham,

I'll be glad to help you if you specify DDL, what you have coded so far and expected results.

Let me suggest you to take a look at this...

260 posts in 13 days...

You guys are posting crazy fast!

Never leave the thread alone for such a long time!

mazzz (7/1/2009)

---

GSquared

You might like this site - for each word you get right, they donate 10 grains of rice through the United Nations to end world hunger.

Free rice

You might want...

I just noticed you need it for SQL 2K, while information I provided is for 2005. Sorry.

It works quite the same anyway, you have only a different tree in the...

You can do it from the GUI, maybe you'll find it easier.

In the object explorer for the linking server expand "Server Objects", then "Linked Servers".

Right click on "linked servers"...

LOL!!! :-D:-D:-P:-D