In addition if it is making a poor index choice it is usually a fact of poor maintence habits or poor indexing choices themselves. Could you post the DDL for the...

If not the backup drive itself being full check that either the data drive is not full and that the C: drive is not full as well as the drive...

The problem you have is that your data is not sorted the way you assume and is based on the rules of the data type in use.

If all the data...

Interesting thou. Do you know why the transaction disappeared later?

TPM is the measure of the number of transactions a system can process on average per minute based on the measure of a defined period under load. As far as...

I beleive the sort i due to the Custered Index from what I can see. It is sorting for insert performance to minumize data movement on pages as much as...

I have installed every patch level on a SQL 7 machine and you just occasionally run into mysterious issues sometimes. Just make sure you do a full backup before the...

1) Try inputing the time in as '20:30:00', sql i sometimes finacky. Or use '08:30 PM'. Sorry no SQL here to verify I am telling you right but I do...

I would suggest if the vendor is stating it can then you put the responsibility on the vendor to find and restore the transaction otherwise the user will state the...

Sorry nothing setup to test here. However hav you run in debug and verified which line is failing and stepped thru the process in full?

Dim objPkg

 ' Get Package object

 Set objPkg = DTSGlobalVariables.Parent

This will get you a reference to the package itself. Then you can access all the properties you just mind have to google...

Look at the destination and make sure the field is big enough. Many times exports to excel with default to 255 characters for the field so anything larger is truncated....

Please be carefull not to duplicate posts. Leave replies here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=178989

Can you be more specific on how they relate. I wouldn't think everyonw in the sales dept would have the same salary. I would think the company table would inherit...

I agree here for the sake of yur question. Since you are not changing the strucutre itself and since these columns should obviously not be joining multiple tables and since...