Viewing 15 posts - 5,731 through 5,745 (of 9,722 total)
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
At this point, I would say the package is corrupt or something is wrong with your install.
Start over with a brand new package.
June 16, 2011 at 11:58 am
quillis131 (6/16/2011)
June 16, 2011 at 11:25 am
jcrawf02 (6/16/2011)
"You HAVE to click this link …. It is a video name generator and gives you new (made up)...
June 16, 2011 at 10:29 am
Why do you have the container and the task TransactionOption set to two different things?
Package Level should be Required, not Supported.
The other two can be (probably should be) Supported.
Currently,...
June 16, 2011 at 10:25 am
Viewing 15 posts - 5,731 through 5,745 (of 9,722 total)