no problem. glad you got it going.

there is a dropdown in the job step to specify database. verify that the database displayed there is the database that contains the procedure.

try thi in your job

execute dbo.processname @var1 = null, @var2 = null

can you post what you have in you job so I can see what you are currently passing through?

I think this is what you are asking for

execute sp_procedure @var1 = null,@var2 = null

I have not found a way to reuse the disks. I suppose that they did that just to ensure all instances are independent of each other. We use mount points...

BOL is books online (just the help documentation)

I had never heard of switch either.

it depends on how you want it setup. Say you have a 3 node cluster and 2 nodes have active instances. if you are adding a 4th node, and you...

you need to add any node that you wish to be able to fail that instance over to.

you should be fine. SQL only counts the physical processors and not how many cores you have.

we usually add the SQL service accounts to the local groups "distributed COM users" and SQLSERVER2005DTSUSER

if that doesn't get you there, I have one more thing you can try,...

try using the CASE/WHEN clause, it's well documented in BOL

I would suggest adding an if exists clause to see if the table exists first. Just change the name of the object below.

IF EXISTS (SELECT * FROM sys.objects WHERE...

BAK files zip quite nicely, or you could use a third party tool like litespeed from quest, I have had good luck with that one. I've also heard there is...

what I found more useful than spotlight is thier product called performance analysis.