Colin is attempting to provide help.

Questions are not always clear as to their intent, giving more information rather than less helps other to help you. Colin is just trying...

I've not been able to get xp_smtp working on 64bit and have reverted to the cdosys proc.

From a thread in another forum "It means that the data in the file for a given field is longer than the

destination column in the database.  It can indicate a problem...

I used to use Litespeed. The only problem I have experienced with it is the price point. Basically there is a per cpu cost, when you add the professional option...

Create a table that has the same schema as the main table, let's call it TABLEA_WORK.

Using DTS put the data into that table.

If there are no problems, use the primary...

Couple of things that I can think of offhand.

Firstly, check the database recovery model. If you can set that to simple recovery then it will run significantly faster. Secondly, are...

There's nothing that you need to set that will apply to your installation.

Certain switches need to be applied to address higher memory levels, however given that you are running Windows...

You would be able to update unreplicated objects, however none that are replicated.

Insert the data into a worktable, then run your validations and follow that with your updates. Finally drop or truncate the work table.

how about using datename(dw, getdate())

I use this for my backup scripts. For my dev and stage servers if the result is Sunday then it does a full backup, otherwise it's...

Take a look at Quest Benchmark for Database. You can get a 30 day trial and it's good. Told me a lot about the hardware I was implementing.

Forget TDP. Backup all your databases to disk and backup those to tape. Then you can restore the database directly. First install SQL, then restore the master, model, msdb databases,...

Could be the XP sp2 firewall thing, or it could be that the xp machine is sitting in a different domain (debugging does not work across domains).

It's not the neatest thing, however it will give you the results you are looking for.

create table #x (student char(1))

insert into #x select student from where subject =...

The user account that you are using is different from the account that you log in as usually?