I would say that the developers that have written a lot of VBScript to get around some of DTS's limitations are going to be in for a lot of work...

There is a style called Formatted that puts in <PRE></PRE> tags, but it seems to do on a line by line basis. In the old forums you used to be...

Chris

The forum formatting for code isn't what it used to be, but they'll get there. That's one of the things that makes this a great site.

It also seems to have...

Even better, write the message to a table in the database. That way you can produce reports on what was done, when and how often.

I've had experience with a quad P3 500mhz out doing a dual P4 2.8ghz. This was mainly due to application and database design though. Some of the queries where horribly over...

Forget temp tables and the like. Here's what I run every 5 minutes on the server.

INSERT INTO dbo.tblActivityLog ( 
SPID, LastUpdate, Status, Login, HostName
, BlkBy, DBName, Command, CPUTime, DiskIO
, LastBatch,...

Ah Ha ... where did you find out about the parameters for xp_dirtree?

The execution status comes from sp_get_composite_job_info which in turn comes from xp_sqlagent_enum_jobs.

Try any of the ASP/Dev webistes.

http://www.asp.net
http://www.15seconds.com/
http://www.4guysfromrolla.com/

etc...

I would remove QA from the users and give them an ASP page. From this page they could launch and monitor the process.

Less chance of things going haywire because the...

The copy SQL Objects task will BCP the data out to a text file, truncate the source table and then BCP the data back in. This happens for each selected table in...

You could still use something similar to Noeld suggestion, just use OPENQUERY instead of OPENROWSET. Then you can use a linked server. A server can have a linked server that refers...

It's nothing to do with the join syntax. In an outer join query, you can't specify criteria in the where clause for the table on the opposite side of the...

Firstly I don't know why you convert your date parameter to datetime then back

to nvarchar. Why not just use the passed value as it is?

In the statement where you convert...

More CPU power so the process completes quicker, more memory so SQL Server can cache more data, faster Disk I/O subsystem to process reads/writes faster.

Naturally any of these will require...