Fraggle (8/29/2008)

---

Well as I understand it, there is a difference.

A Job can have multiple schedules included with it. A maintenance plan can have only one schedule. ...

Also, I have noticed that jobs have a lot of power in that there's a lot of options in the window which pops up when creating a new job (not...

A Sql server maintenance plan is generated by a tool provided by MS, either Enterprise manager in 2000 or SSMS in 2005. It attempts to provide a standard set of...

I am agreeing with the other post but back when I worked with Oracle I recall the "nvl" not working through ODBC or OLEDB. I think what I did was...

Some AV cause issues

NOD32 definitely

By using the convert and the trim on the join it usually takes the query off any indexes that exist and can significantly slow any queries.

Have...

I don't know if you will find them useful but I have put most of my backup scripts on a blog. I know it is not well organized but they...

Two possibilities I can think of:

1. You created a new subtask in the database maintenance which is managing to jobs in the agent

2. (This happened to me) You renamed the...

Are you running SP2? I found maintenance plans almost unworkable until then.

I have mostly given up on the maintenance plans as they do not seems as stable as a...

If your are on a domain the easiest is to create an account DOMAIN\[This task user] and if possible avoid mixed mode. Security is much easier to maintain this way.

This probably is an issue with what user the agent is running under Local Service this user will not be recognized by the other machine and the operation will not...

I have made the mistake of using package configurations and forgot to change the path and or table name in the config and spent a while being frustrated the whole...

I just did a quick test but all the tables for mail seems to be very straight forward

For example, [msdb].[dbo].[sysmail_*]

I transferred an account to my test box and...

The error you are getting is because you are trying to reference the alias instead of the data itself.

For example:

DECLARE @a int

DECLARE @b-2 int

SET

A few things you need to look at as long as the file runs fine when you run it.

1. What user is the SQL server agent running as? If the...