Sorry if there wasn't enough information in the original post.

The application calling the SP would know if it was an insert or an update. The...

Neither SQL Server nor the Email Server is a DC. Also nothing in the NT Event log.

I will apply SP4 on a development box and...

May not be the best solution.

Create  table #TableA (Trailer_ID varchar(2), Qty int)

INSERT INTO #TableA Values ('AA',5)

INSERT INTO #TableA Values ('BB',4)

INSERT INTO #TableA Values ('CC',6)

Create ...

create table #temp_dates (

DateReceived datetime,

TimeReceived varchar(10),

DateResolved datetime,

TimeResolved varchar(10) )

INSERT INTO #temp_dates VALUES ('2005-09-01', '8:00', '2005-09-01', '10:30')

INSERT INTO #temp_dates VALUES ('2005-09-02', '9:30', '2005-09-03', '8:30')

Shawn - thanks for your input. SQL is still on SP3. There is no overlapping of jobs. Reindex and Sync are two different jobs 1/2 hour apart. Reindex...

I rebooted the server yesterday and still no improvement in performance. The tempdb has the intial space set to 500 MB and set to grow in 50MB increments. It...

I don't have that numbers with me, the test server has been restarted since then.

I found that the temp DB has grown to 6 gigs and it has been quite a while since SQL Server has been restarted on the production server....

Can you check the column name of the insert table. Most likely, the column name does not match.

But I may be wrong...

This script is executed in DTS and the log file shows this error randomly. It does not generate this error every time. Strange !

I did a select (column - 0.60) and the result was 0. Should I not get 0.000002 ?

Does the drive mapping exists on the server ? It's likely that the path to the batch file may exists on your PC and not on the server.

You can run a SQL Trace to track the progress of each step in the DTS package.

Or you can create a log file when the packge is executed (DTS package...

The VB.net app is being developed which reads SQL tables. So parts of application are in VB5 and VB.Net

I forgot to explain. There is a VB 5 app that uses Access tables and we are in the process of migrating to VB.Net with SQL Server.

Some of the...