hahahaha... yeah, I won't get you started, if you promise not to get ME started... I have recently posted here about it being "Daylight Saving Time"... NOT Savings... or Daylights...

I just modified a plan, asked it to fix minor problems... and it completed in 5:39... no problems, success reported, and no messages anywhere to the contrary.

I would appreciate it...

no stored procedure for stopping and starting the merge agent according to my review of BOL.  There is a merge agent utility with a ton of optional parameters... i.e., there's...

Okay, your question appears to have been answered... so, now let me "enlighten" a bit and see if there is expanded commentary.

A file with the extension ".bat" is commonly referred...

You might try using an explain plan, first against your test environment, and then against your production site (or just production data).  Explain plans modify themselves over time based on...

It always surprizes me that even with the message "ignored" that the step fails... and what I usually see is that the files are not purged.  We split our maintenance...

That's a VERY good question and nobody answered.  I found that packages worked just fine with or without them... those and data source views.  One of the big advantages to...

files only... for all of noggin's reasons.

effectively that should be the same as re-scheduling the job, right?

Portability of DTS packages is a big issue, always has been a big issue... I found one guy who posts...

if anyone executes an unlogged transaction (for instance, truncate) the full backup and subsequent log files can only be restored/recovered up to that command.  After executing an unlogged transaction you...

Think I would start with BOL.

I went on production yesterday to LOOK at a DTS package... and as I clicked on "design" my mouse jumped to execute... it was a "data pump" that ONLY gets...

I put a script in the library here about two weeks ago that was named "Switch_Database.sql", and it does it all... It was designed to allow a snapshot to be...

good article; but sometimes DTS packages seem more "mystic" than this... scheduling, security context, proxy accounts, service accounts... thank you Bill Gates... unfortunately, it doesn't seem that SSIS is any...

Master and MSDB are special cases... and perhaps the easiest way to have a backup is by shutting down the service and taking an OS level backup of the .mdl...