Do not forget to use the tablock parameter to improve performance whilst using the bulk insert statement.

Brian, think that you should implement a time delay on the question so that all the hacks like myself cannot nip into BOL and find the answer. Guess the real...

I guess that when you get to this stage of affairs, what you are really talking about is writing your own locking table, and keeping track of 'system locks', rather...

As we all know 'I' (via the constraint object)is enforced by SQL Server whilst the data is still in the data cache, and has been prompted (wanted to say triggered...

On the whole i agree with DAVNovak, that every table should have a unique reference point.

Just because you have a PK does not mean that there is no data...

Probably missing the point as usual, but since Access and SQl Server have different schemas, is not impossible to copy objects(apart from base) between the two.

MS recommend that System monitor is used when checking hardware issues.

JPipes is correct, unfortunately with the current versions of SQL Server, many of the date settings can only be set for the current connection, and not as a default for...

I suppose that you could run a series of aggregate functions and the rows that you will be moving in the original table, then carry out the same functions on...

Why not code the insert into statement, bet it will be quicker than DTS. If you need to create the destination tables, then select into. You would then have to...

On the remote server you will need to create a share and make sure that MSSQLServer can write to the share. Imagine your server is called sql1 and the share...

You could try setting the recovery model to simple prior to running the nested transactions, and then resetting the option after the transaction has completed. When the simple recovery model...

Primary Keys are stored as constraint objects within a database. All objects must have names, as mentioned in a previous post, the names should be meaningful and follow a naming...

Maybe you could simplfy matters for yourself by creating a single column surrogate PK, and that would help Access with the date handling routines.

Try creating a non - clustered index on the hitdate column, because that should improve performance for the totalhitstoday report. Covered queries (queries where all the columns listed have an...