I agree with Leo - there is no reason for you to have to implement something like this. If there is a problem with tempdb - then you need...

Instead of trying to use IN and forcing the comparison using character strings, you should convert it to an EXISTS or OUTER JOIN comparison on a correlated query.

For example:

SELECT *

...

You can validate it yourself with minimal effort - RDP to the server and use the cluster administrator console (is this windows 2008 also, or 2003?). The administration of...

I am not sure about the reference to the recycle bin in the error - that seems a bit suspicious.

Is the I:\ drive a cluster resource? Is the mount...

If your log continues to grow - even after transaction log backups are run, then you have an long running open transaction that is preventing the space in the log...

The table that will be considered the preserved table is the table that is logically to the left of the table you are joining in. The order of the...

If your database doesn't have any tables - then the easiest way to reclaim the space is to drop the database and create a new one.

If you have objects in...

No - you wouldn't want to do that. I was thinking you might have just been starting the other jobs instead of running them from the new agent job.

Each...

In your new job - are you starting the other jobs, or did you setup new job steps for each package and set that step to run the SSIS package...

You should not set the min memory = max memory. That could cause issues within SQL Server.

Since this is a dedicated box - there is no reason to set...

I use maintenance plans myself, and unlike others - have found that I can do everything needed without having to create additional agent jobs to call specific scripts.

When I have...

Just drag the task into the maintenance plan 3 times. Set the precedence constraints appropriately - and there you go.

Maintenance plans are not available in the Express Edition - which also does not have SQL Server Agent.

You have two options:

1) Upgrade to an edition that supports maintenance plans and...

Are your users logging into that machine - or are they logging into their own machines and trying to connect? If they are logging into their own machines, are...

sqlbuddy123 (7/20/2010)

Try to switch to Bulk Logged recovery model and take frequent Transaction Log backups. This would do minimal Logging and truncate the TL.

...