I have heard several 'fixes' for this problem. From what I have read it appears to be a major design flaw in the excel provider which covers all versions including...

thanks for the advice. I made your change so it only udpates where different (100% are different on the first runas they are defaulted to -1).

I am going to try...

Following on from Jim Fosters comment about the "BEGIN TRANSACTION; INSERT INTO @Vendors VALUES (1, 'Wicked Widgets Inc.', 'A');ROLLBACK TRANSACTION" statement. I ticked this as not being valid. This is...

Thanks for the advice. I modified the first line of your code to;

Update Tmp SET Tmp.CatList = COALESCE(Tmp.CatList + ',' + C.CatID, ',') + C.CatID

and it worked great. In the...

I dont think option 3 is possible. I think you require a 64 bit OS to run 64 bit SQL. if you mean option 3 is 64 bit OS with...

The communication path is as follows;

standalone USB 2.0 NAS -> linksys USB to ethernet converter -> gigabit switch -> SQL server

yeah i did do. i have looked at the  http://support.microsoft.com/?id=812915 and it appears to be my scenario except i am running sql 2005 SP1. i have tried unloading the counters with...

you need to install the client tools as well as the server. Just insert the installation disk and the tools are accesible through an option on the splash install screen

I have a similar issue but with a footer saying the number of rows in the text file. Does anyone know how to drop the footer row without inserting into...

The best way depends on the answers to various questions;

1. is this a one of request (are you certain. it is a lot less effort to record this info and...

if you look in books online under "error 823" it explains what is wrong. check the servers system logs for any hard disk or io subsystem errors. if there isnt...

I am assuming you have an NTFS file system in which case microsoft say "2 terabytes should be considered the practical limit for both physical and logical volumes using NTFS". The...

thanks both of you. the jobID is used for presentation as you guessed but more importnalty for comparing job n (or series starting at job n) with another job (or...

I observed similar problems with an MSA1000 and 2 compaq servers (both 4gb ram, 1 had 2cpu the other 4cpu). The performance degraded tenfold when both servers were accessing databases on the...

NULL can never be compared to anything, it is like infinity you can never be equal to infinity (< or > either)

if you want to evaluate NULL values to be the...