So creating steps in the sql job and scheduling the job is basically the same as the maintenance plan. If SQL jobs are just the better route to go...

So any recommendations on how I can use a plan to make sure the plan does not move forward until the task is complete.

I will move forward on getting the...

For my 2008 server maintenance plan yes it looks like that is what it does:

EXEC msdb.dbo.sp_start_job @job_id=N'e24ac97f-381c-4e85-b79d-fbfc8ce30e58'

For my 2005

EXECUTE [dbo].[IndexOptimize] @databases = 'USER_DATABASES',

@LogToTable...

Well it helps if it is accurate which I'm guessing it is. The two scheduled jobs that exist in the SQL agent job list for these maintenance plans are...

I had this issue in the past. Not sure if the error was exact but everything else is.

My solution unfortunately was to uninstall SQL Management Studio and reinstall it.

Hardware is a virtual machine so this is not a problem.

I may have to look at 2008 x32 until we can schedule the application upgrades which could be years. ...

I would like to ask if there is an issue with a open active transaction that is active but the log_reuse_wait_desc is Nothing (0) which means Currently there are...

I agree 100% with the statement of "poor programming". This software is the worst. I kill one issue and another just pops up. It is like...

ok found the offending EXE causing this issue but I have some questions on the tempdb. This will have to be looked at why this is happening by the...

This weekend the tempdb log file reduced after a reboot and settled around 15GB but is now up to 41GB and my users are complaining of slowness. We have...

Found a job created called Commandlog Cleanup

Doh

I searched and searched for info on the site never found anything.

Here is the SQL if anyone is interested:

sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master...

Everything I pasted was all ran one after another on the day I posted this which I believe was 10/4.

Yes it looks like two db's have it enabled:

SELECT name, is_read_committed_snapshot_on...

Dba has the ability to control the mssql services. They have the ability to rdp but have standard user rights once on the system. They have SA level...

Yes I think the commands in SQL run execute as the service account log on as (system) so I think backup and restore would not require any additional NTFS rights.

In...

I want to say thank you very much for all your help.