Viewing 15 posts - 1 through 15 (of 26 total)
Thanks for the info. I did DBCC TraceOn (1800,-1) with no affect and see continued misaligned IO errors. Ideally, Id want our disk sectors matching at 512e or 4k, but...
November 30, 2015 at 9:10 am
What are your thoughts on something more like this was individual loops for each table to be deleted from:
DECLARE @DeleteDate DATETIME ,
@RowsToDelete BIGINT
-- Calculate the Min....
March 12, 2013 at 7:13 am
arnipetursson (3/11/2013)
If 200 RawVehicle record have 400 child records in one of the other tables,you will delete all 200 RawVehicle, but only 200 of the 400 child records.
got it, and...
March 11, 2013 at 1:23 pm
arnipetursson (3/11/2013)
If if it is one to many, you will leave orphans in the other tables.
One way to do...
March 11, 2013 at 12:57 pm
Lynn Pettis (3/11/2013)
March 11, 2013 at 12:40 pm
Perry Whittle (4/27/2012)
My preference would be to invoke the SMO objects directly within C# to backup the database
Agreed. I've even used the SMO Restore class to loop through a directory...
May 1, 2012 at 6:25 am
opc.three (7/29/2011)
zlthomps (7/29/2011)
Koen Verbeeck (7/29/2011)
What if you connect the first FELC with the second one using a precedence constraint? Does it work then?
Yes, it does - But I would ideally...
July 29, 2011 at 11:17 am
Koen Verbeeck (7/29/2011)
What if you connect the first FELC with the second one using a precedence constraint? Does it work then?
Yes, it does - But I would ideally be able...
July 29, 2011 at 7:51 am
Here is a shot of the failure, again without an error on the progress tab...
July 29, 2011 at 6:27 am
zlthomps (7/28/2011)
opc.three (7/28/2011)
The only thing I can come up with for this, and it is a guess, is that there is only one copy of...
July 28, 2011 at 2:47 pm
opc.three (7/28/2011)
The only thing I can come up with for this, and it is a guess, is that there is only one copy of the...
July 28, 2011 at 2:45 pm
oh nm, guess I posted too soon. I was using the following expression to build the connection string for the ADO connection:
"Data Source="+@TmpViewDBInstance+";Initial Catalog="+@TmpViewSourceDBName+";Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=SSIS-View_Staging-{000EBA5B-414B-447A-B0F6-D30043C11560}"+@TmpViewDBInstance+"."+@TmpViewSourceDBName+";Auto Translate=False;"
But this is a...
May 18, 2011 at 1:35 pm
oh btw, I left out the lines where I close my connection and pass success to Dts.TaskResult...
TrgtDB.Close();
...
May 18, 2011 at 1:22 pm
Thanks for the article, very good read.
January 4, 2011 at 7:13 am
Viewing 15 posts - 1 through 15 (of 26 total)