You can do it in .Net using the object model which gives you the ability to see all the proteries of all the individual task hosts within the package. ...

I don't think they are stored in a table at all. Maintenance plans are SSIS pacakges and looking at the text of one I saved out I found the...

SQLRNNR (12/8/2011)

---

Elliott Whitlow (12/7/2011)

---

Not sure I agree...

It sounds like you are moving a lot of data around at those times. I've got to wonder if those sprocs are the best way. I tend to...

Not sure I agree with that.. ...

Don't give them a choice.. Once the disk is presented to the machine it can be formatted any way you like.. I wouldn't bend on this topic.. ...

One of the things that I strongly recommend is formatting the SQL drives as 64K clusters. Which as I understand it allows SQL to grab 1 extent of data...

TravisDBA (12/7/2011)

---

Understood, but I think most people already realize that TDE is "transparent" and it is "at rest" encryption, so it does not cover all of the INSIDE possibilities, breaches,...

A little rusty on my expressions..

And this was a lot harder than I expected it to be..

Tried:

SUBSTRING(Genrder,1,1) == " " ? NULL(DT_STR,1,1252) : SUBSTRING(Gender,1,1)

It didn't like DT_STR, SO, I tried:

SUBSTRING(Genrder,1,1)...

There are lots of strategies that can be used. But I am a fan of RAID10 or Raid 0 + 1 or Raid 1 + 0, basically mirroring and...

TravisDBA (12/7/2011)

---

I think we are talking about two different things here. I am referring to the ability for someone to take sensitive databases offsite either in pieces or as a...

hanrahan_tim (12/7/2011)

---

Thanks for the reply Elliott,

When you say your not a fan of granting server level access does this mean if given the choice you would opt for a single...

Well shoot.. I seem to remember a similar problem when I was writing my inventory and auditing package thats on codeplex.

I elected to use a user with sysadmin rights...

Not a fan of linked servers.. They have their place but I caution against using them much.

CEWII

Wow that is a lot of questions..

Whether the master package actually fails is somewhat under your control, however, I think if any of the child packages fails it will indicate...