Here's an option that can be used. You will need to determine what you want to audit in msdb for the jobs, but this can get you going in...

see if this is of any help

http://www.sqlservercentral.com/blogs/sqlballs/2013/01/21/how-do-you-query-maintenance-plan-package-metadata/

Klink

I have worked on a few in the range of 8+TB.

I have also supported 4500 Instances with multiple databases each.

I have done very busy OLTP and also some very boring...

Yeah, it really looks like it will be the no-fun approach to solving this. New database and migrate the data.

dingleberry

You are welcome.

You could also take a look at the patient encryption demo script provided in this download

http://www.sqlskills.com/resources/conferences/201203devweek_security.zip

That is a session put on by Bob Beauchemin.

New Born DBA (2/21/2014)

---

SQLRNNR (2/21/2014)

---

Try dropping the batch sizes down.

Also, are you loading the table as the source or are you loading it via a tsql statement?

Sometimes SSIS likes (ok...

Here is a tool that should be worth your while.

http://sqlserverlst.codeplex.com/

Lara built the Enterprise Policy Management Framework and has this product out there to do RLS and CLS.

Steve Jones - SSC Editor (2/21/2014)

---

stormsentinelcammy (2/21/2014)

---

You'd hope if you're working on instances...

Try dropping the batch sizes down.

Also, are you loading the table as the source or are you loading it via a tsql statement?

Sometimes SSIS likes (ok a lot of times)...

jcrawf02 (2/21/2014)

---

Jeff (and all you guys who helped test the delimited split 8k) are solving problems you don't even know about. Found this in my inbox today from a former...

In your migration package, are you batching the record export/imports to 10,000 or something other than the default (which tries to do the entire table)?

SQL Guy 1 (2/21/2014)

---

Unlike Files,...