Viewing 15 posts - 5,731 through 5,745 (of 9,726 total)
Jeff Moden (6/17/2011)
Brandie Tarvin (6/16/2011)
If you don't have an Identity, add it to the table.
I prefer a method which exploits the IDENTITY column, as well, but it's just not possible...
June 17, 2011 at 5:13 am
John Mitchell-245523 (6/17/2011)
Brandie, a full backup doesn't break the log chain, although a lost or corrupted log backup certainly would.
Oh, yes. And finding that bit of information out when you...
June 17, 2011 at 5:07 am
John,
Sorry. You are correct. A full backup doesn't usually break the log chain.
I suppose I should have just said "chain" without the "log" because I've seen people do...
June 17, 2011 at 5:04 am
Craig Farrell (6/17/2011)
Phil Parkin (6/17/2011)
Actually, I was wondering about that. Does that mean the problem is that she has to get a full blow version of SQL Server to get...
June 17, 2011 at 4:44 am
Glad we were able to help.
June 17, 2011 at 4:43 am
vaibhavraut88 (6/16/2011)
Great Job dude ur script works. but can u explain me that code.
Look up Common Table Expressions and Row_Number() in Books Online, or Google the phrases. There's a lot...
June 17, 2011 at 4:40 am
Sachin4all (6/16/2011)
I installed 2005 sp2 and got it fixed
Ahha! Ye ol' Microsoft Bugginess were the problem, were it?
That makes sense. Glad you got it fixed.
June 17, 2011 at 4:37 am
sqlnes (6/16/2011)
We have heavy IO on tempdb right now and the size of tempdb grow rapidly. ... Our programmers use temp table a lot.
Hey, be careful about this correlation.
Temp...
June 17, 2011 at 4:35 am
Since no one actually verified this for him:
hammad772001 (6/16/2011)
June 17, 2011 at 4:27 am
Craig Farrell (6/16/2011)
Brandie Tarvin (6/16/2011)
But the OP is having issues with SQL Express 2008.
Just re-went through the thread and we're on the 2k5 forum... where am I not seeing the...
June 17, 2011 at 4:22 am
Craig Farrell (6/16/2011)
I'd heard rumors of transactions and checkpoints not behaving nicely in 2k5, I'm going to need to explore a few other packages I'd expected to behave themselves.
I've had...
June 16, 2011 at 12:53 pm
quillis131 (6/16/2011)
No luck....I tried to change that ...the same message. And I am not sure what my version is ..but can definetly say it is 2008(sql express).......This seams a bug
Check...
June 16, 2011 at 12:49 pm
<headdesk>
Really wish people would state what version they are using at the START of the thread when posting in a multi-version subforum.
June 16, 2011 at 12:31 pm
Looking at 2008 BOL, there is a very important note about the checkpoint file:
Set the CheckpointUsage property to one of two values:
Select Always to always restart the package from the...
June 16, 2011 at 12:29 pm
quillis131 (6/16/2011)
which version are you using, mine 2008
Right there might be the source of our communication issue. I'm using 2005 and having no trouble at all. And I assumed you...
June 16, 2011 at 12:23 pm
Viewing 15 posts - 5,731 through 5,745 (of 9,726 total)