PowerShell yes, SMO no.

Maybe something like this? (I've "borrowed" most of this and used it but don't make me explain it!)

$SB = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=msdb;Data Source=$servername"

$SQLcon = New-object system.data.sqlclient.SqlConnection

$SQLcon.ConnectionString =...

take a look at using the SQLCMD utility and stored procedure sp_start_job, something like (may not be exactly right):

SQLCMD -S servername -Q "exec sp_start_job 'sqlagent job name'"

Jim

I need to install both Windows 2003 SP2 and SQL 2005 SP2 - any ideas on which should go on first?

I saw this when I ran SQL in a VM and it was running a heavy load. I moved the application to a physical server and the problem went...

I was looking at Perfmon's SQLServer Databases Transactions/Sec - is that a good counter?

We do sorta have the clients setup that way, the customer record has the database to connect...

Try this:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

No experience with LiteSpeed in a VM, but I'm using SQLBackup from RedGate in a VMWare Server + Windows 2003 Server + SQL 2005 environment with no problems.

Phill -

Thanks for the info, I'll work on writing something with a little less brute force.

Jim

Everything I've read says to NOT turn on autoshrink - you can't control WHEN it will shrink and it may pick your busiest time of day to do the shrink.

Jim

ok, but does shrinking cause fragmentation of indexes?

I run the script in the BOL to defrag my indexes on a weekly basis.  If I run the script to defrag the...