If you use a SAN or NAS, where is your tempdb located?  I had a server that reacted this way because tempdb was on the SAN.

I wrote the whole thing inside a sql job, using vb sripting to control the files and os commands for things like ftp.

I would suggest that the first stored procedure get changed.  Instead of just returning the result, let it update database B.  That should be faster than using DTS.

Do you get any errors or does it just return the wrong result?  As far as I can see, the problem is that the CASE statement should be inside the...

1. People respond directly to the advertiser.  Too ashamed to post their credentials for the world to read.

2. 99% of the jobs posted...

1. People respond directly to the advertiser.  Too ashamed to post their credentials for the world to read.

2. 99% of the jobs posted...

Mine: 300GB (Systems and Games)

My son: 600GB (Games, Movies & Music)

I have never set up transactional replication, only log shipping, but assuming that the replication is working, try setting up a transaction backup job for the sweetwater database every hour...

You must also watch out for spaces or actually the lack thereof.

Eg: SET @Sql1 = 'Select field'

SET @Sql2 = 'From Table'

EXEC (@Sql1 + @Sql2) will fail bcause @Sql1 + @Sql2...

Imagine a million records or more per client.  Imagine all the clients info in one database.  Not too big for SQL but definitely a performance issue.  Now, when you get to...

I agree, no price on their website and I stop looking further.  That is the first thing I need to discuss with my seniors.

Will teach me to write full sentences. 🙂

I meant that there should not be a major speed difference between querying a table direct or using a stored procedure to query the...

You could put the 2 packages in a job as 2 different steps with the 2nd step only executed on success of the first:

Execute Package 1

|

| on success

v

Execute...

The DTS package runs on the client PC and the job runs on the SQL server.

Try logging in on the SQL server (console) with the SQL Service Agent user account...

1. I assume the stored procedure returns data from multiple tables, because if it returns data from one table there would be no speed increase.

2. You do not need a...