🙂 Well said Randy - SSIS is a bit of a bug filled nightmare in my opinion....

No - its a simple recovery model on the database and it is not a one off. Basically marketing want to know the number of Inserts and Updates made to...

Hi Alzdba - yes you are right - might have to use triggers in that case - but as there are over 200 tables in the database I was hoping...

Hi everyone - thanks so much for the replies - starting to make sense now but as I read this definition of rowmodctr from the microsoft site:

Counts the total number...

A good DBA will never stop learning - the knowledge to be gained in this field is infinite in my opinion - GUI's can make more mundane tasks easier...

Hi Alzdba - thanks for the reply - not quite what I was looking however....

I did manage to get this query that can run against a database:

SELECT distinct sysobjects.name AS...

Hi,

Still searching for this one - any help really appreciated,

Cheers,

Jack

Hi Alzdba / Robert - many thanks for replying to my post - food for thought for sure - we have removed a transaction from a stored procedure that was...