What did you enter for the job step? Just, "XP_CMDSHELL 'wscript.echo " Hello World"'?"

You could also...

CREATE PROCEDURE SP_name (it doesn't really start with SP_)

@variable_1_from_CRM varchar(13),

@variable_2_from_CRM varchar(10),

@variable_3_from_CRM char(13),

@variable_4_from_CRM char(10),

@flag varchar(1) output (also for CRM so that it knows if the SP was successful)

AS

declare @Activity_Title...

Oops- I was talking about the log file, too.

If you run the following, do you get a reason in the log_reuse_wait_desc column?

select name, log_reuse_wait, log_reuse_wait_desc, recovery_model_desc

from sys.databases where name = 'YourDB'

They kind of work back and forth depending on what you want to accomplish. You can get rid of the CXPACKET waits by setting the Max Degree of Parallelism to...

Check out what you're seeing in dbcc sqlperf(waitstats) for SQL Server 2000 or sys.dm_os_wait_stats for SQL Server 2005. If you find that your CXPACKETS are more than 10% of the...

You could create a clustered index on your #temp table. That would force the order to be however the index is ordered because at the very bottom of a clustered...

A job in a software support position might be just the thing.

In my last job, I worked intensely with Oracle (but SQL - by and large - is SQL). I...

Depending on what you're wanting to do, transactional replication might be what you're looking for.

You have two servers, local and remote. The remote server (or instance) must be a linked server:

From the current server write this:

SELECT a.Filed1, b.Field2

FROM LocalTable a

JOIN LinkedServer.OneDB.dbo.RemoteTable b

...

I've looked around and haven't found any references to SQLDMO, but it happens in both our SQL Server 2000 and 2005 databases.

Oh, that's right - that's...

What you're seeing is an artifact of the estimated cost values. SQL Server can't know how long a query is going to take to run, so the estimated cost is...

Yes it does. It turns out that that's not necessarily the best thing to do. In fact, even on a machine with 16 processors, the MaxDop would be better set...

Interesting - I just went through this same process myself last week, but I did it a little differently becuase I was concerned about the same thing. Instead of setting...