Here is a product that covers just about the entire gambit for audit purposes...

http://www.beyondtrust.com/Products/PowerBrokerDatabases/

Yes this is very possible but be concerned about some of the problems using Access as a front end could cause if not careful (new session created for each form...

When the table is coming from a variable, the entire sql statement must be done via Dynamic SQL. It can be done, but you have to set your entire...

David.Poole (2/4/2014)

---

@jason, that is a very good point. Under the UK data protection act an individual can ask that their records be removed in certain conditions. Imagine having...

Igor Micev (2/4/2014)

---

Hi,

Heavy load.

My approach would be like:

You can change your package to use the Foreach loop container, put a data flow task in the loop container and then...

For the deletion of the files you could also use a Script Task. I find it to be more useful than the File system task in some cases.

If you...

You would need to change your multi-tiered cursors to be a dynamic statement and execute that statement.

The statement (to get the date pieces - converting to dynamic will be an...

Will the table name always be formatted as "Stats" + yyyy + mm?

Have you tried to loop through the table and assign the "query" in the table to a variable, then execute sp_executesql with the variables etc?

L' Eomot Inversé (1/20/2014)

---

raulggonzalez (1/20/2014)

---

Sure, but considering the results differ from 2008R2 Standard to Enterprise, if that was the latest version, it'd be still a problem... I've no 2012 Enterprise...

You can do that via SSRS, Performance Monitor, or by dumping the data into excel on regular intervals.

I am curious how many people destroy the old backups that belong to no longer existent databases or that are well past the retention policy.

From looking at a few hundred...

From the options listed I think a fair bit of logic could help deduce the correct answer.

toke

Cool - good to hear.