1.  The problem COULD be the 5mm records and you are running into a buffer problem.

Have you tried importing the file directly into a "staging" table that has 1 column...

Unfortunately, you need to either write 10x OR Dynamic SQL.  The good thing is you could build a stored-procedure and call that 1x.....

Try this

SELECT tblDiaryLog.Id, tblDiaryLog.Ticket_Id, tblDiaryLog.LogTime,

COALESCE([name], [admin]) AS [User], tblDiaryLog.Comment

FROM tblDiaryLog LEFT JOIN tblAdmin ON tblDiaryLog.Admin_Id = tblAdmin.Id

ORDER BY tblDiaryLog.LogTime DESC

If you look in BOL (Editions of SQL Server) and select (Maximum Capacity Specifications) scroll to the bottom (Max amount of RAM)

SQL 2k standard can only use 2GB RAM

Hope this...

Couple of different approaches.

1.  On Startup you fire a VBA module that creates the DSN connection with the name and all other information it needs for your purpose on the...

For a different take:

Why not have the SELECT INTO go against a VIEW.  You could set-up a job that runs once a week to CREATE TABLE and ALTER VIEW (using...

I have never done this via DMO however, just from looking at the information provided I don't think that DMO is smart enough to realize that "I" am (local)....

1st reaction was "Dear Lord....  "

It only took me 3 years of begging to upgrade my 1Ghz machine (and only got the upgrade AFTER she started having problems)...

Now she has...

Short answer is NO.  SQL does NOT maintain history.  That is WHY you have VSS

I don't think that this is SYTAX-wise correct.  You need to do FROM tableA INNER JOIN tableB ON tableA.field = tableB.field WHERE tableA.field BETWEEN tableB.Start AND tableB.END

Found this in BOL

I know that this sounds bizarre but, try turning logging OFF for the package.  Also, make sure that the .CSV has at least a carriage return in it...

I think that SELECT @err = @@error will ALWAYS resolve to 0.  To truly capture the @@error SET @err = @@error and then you can do

IF @err <> 0 OR...

I guess question 1 is What kind of UPDATES?  Data or Structure?

IF Data I would create stored-procedures and then GRANT EXEC to them (and only them) and as long as...

I have not used ASP.NET so if this seems a silly question please forgive me.  Have you tried CREATEPARAMETER 1st telling the system which direction the parameter is and of...