Viewing 15 posts - 5,041 through 5,055 (of 5,393 total)
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...
-- Gianluca Sartori
July 14, 2009 at 7:09 am
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...
-- Gianluca Sartori
July 14, 2009 at 6:22 am
Dave Ballantyne (7/14/2009)
with cteResursive(BaseRecordId,RecordID, ParentRecordID, Credit)
as
(
Select RecordId,RecordId,ParentRecordId,Credit
from yourTab
where ParentRecordId...
-- Gianluca Sartori
July 14, 2009 at 6:14 am
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...
-- Gianluca Sartori
July 14, 2009 at 6:13 am
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.
-- Gianluca Sartori
July 14, 2009 at 6:02 am
July 14, 2009 at 5:59 am
GilaMonster (7/14/2009)
Dave Ballantyne (7/14/2009)
IIRC it wasnt a turbo button , it was a 'go-slow for compatibility' button.
Yeah, it was. That was part (maybe too subtle) of my joke. It could...
-- Gianluca Sartori
July 14, 2009 at 5:58 am
Don't know the whole thing, but I can throw in a hint fo a further search: kerberos tickets expiry?
-- Gianluca Sartori
July 14, 2009 at 4:35 am
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...
-- Gianluca Sartori
July 14, 2009 at 4:26 am
260 posts in 13 days...
You guys are posting crazy fast!
Never leave the thread alone for such a long time!
-- Gianluca Sartori
July 14, 2009 at 4:09 am
mazzz (7/1/2009)
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.
You might want...
-- Gianluca Sartori
July 1, 2009 at 3:58 pm
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...
-- Gianluca Sartori
July 1, 2009 at 3:32 am
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"...
-- Gianluca Sartori
July 1, 2009 at 3:23 am
Paul White (6/30/2009)
No doubt all issues are fixed in Microsoft Dynamics NAV 😀
LOL!!! :-D:-D:-P:-D
-- Gianluca Sartori
June 30, 2009 at 3:57 pm
Thanks everybody, I hope everything goes fine!
-- Gianluca Sartori
June 30, 2009 at 3:53 pm
Viewing 15 posts - 5,041 through 5,055 (of 5,393 total)