Viewing 15 posts - 1 through 15 (of 47 total)
CHECKDB came out clear. It ran successfully and didn't return any error.
I guess, I will have to perform some rigorous testing in order to get to the root of...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 13, 2012 at 2:35 pm
I would diable indexes before performing a huge delete and also consider batch deletes as Steve Jones mentioned above to avoid logging problems.
🙂
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 13, 2012 at 2:21 pm
Glad that your problem is solved.
Please try to be as much descriptive as you can going forward. It's always great to provide some sample scripts (Create/Insert) to simulate the problem...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 8, 2012 at 12:56 pm
GilaMonster (2/8/2012)
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
This is an indication that the connection has been terminated at the server....
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 8, 2012 at 11:56 am
Thank you HowardW.
HowardW (2/8/2012)
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 8, 2012 at 11:14 am
shah.simmy (2/7/2012)
if two tabel has two same schema,but not primary - foreign relation,i want to identify matching record from both table.how can i do it,i cant use join thre
You may...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 7, 2012 at 9:21 pm
Koen Verbeeck (2/7/2012)
Rachel Byford (2/7/2012)
I've discovered that it's quite common to get this error AFTER you've had a real SQL...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 7, 2012 at 5:06 pm
Koen Verbeeck (2/7/2012)
Does the task fail immediately or after some time?Maybe you got a time-out or something?
Do you have any parameter mapping or resultset configured?
1) Mostly the first update completes...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 7, 2012 at 9:33 am
Here's another way you may consider. This approach involves the following steps:
1) Fetch the duplicates into a temp table. (The customers with same date in this case)
2) Delete the duplicates...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
February 2, 2012 at 3:50 pm
Crispin Proctor (6/8/2011)
Is the file and xls (i.e. not excel 2007/2010) file?have you put "EXCEL 8.0;IMEX=1;HDR=No" in the Extended Properties? (No quotes)
Hi Crispin, what is the function of HDR? I...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
June 9, 2011 at 1:21 pm
Hi Vijay,
As Koen mentioned above, you may use a simple script task before any other process/task in your package to check the input file existence and hold the value in...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
June 7, 2011 at 3:04 pm
BSavoie (3/11/2010)
________________________________________________________________
"The greatest ignorance is being proud of your learning"
March 11, 2010 at 10:26 pm
BSavoie (3/11/2010)
________________________________________________________________
"The greatest ignorance is being proud of your learning"
March 11, 2010 at 9:04 pm
BSavoie (3/9/2010)
If a package is "encrypted with user...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
March 10, 2010 at 10:54 am
Elliott W (3/9/2010)
It runs ok from BIDS (running as you)
It fails in DTExecUI (running as you)
It fails as a SQL Job (running...
________________________________________________________________
"The greatest ignorance is being proud of your learning"
March 9, 2010 at 9:45 pm
Viewing 15 posts - 1 through 15 (of 47 total)