Thanks - yes I have tried that and it works.
I just thought the TRUNCATE would be captured as an ALTER TABLE event?

Thanks for the reply.

Can this be done for a whole table within a view then, say:
SELECT ... FROM table <COLLATION>
or does it have to be done...

Yes I resotred the msdb database and msdb_OLD but the Policies did not appear under Management/Policies? How do I export them from the msdb database?

I think I figured out this bit:

"I am using a filter: database_name - not_equal_i_sql_unicode_string - tempdb but these are still appearing in the captured events?"

I should...

Thanks for the responses.

Yes I tried BCP but have to include headers. I used the UNION ALL approach to add the hedrers but this failed due to data type differences.

In...

Sorry yes that is in my script - just missed copying it.

Thanks very much Shawn that works!

Only thing now is that the SQL job never seems to complete even though the Powershell script has finished inserting records? Do I need to...

These are the main bits of code I now have having removed the double quotes around the parameter assignments:

param(

[parameter] [string]$ConfigurationGroup,

[parameter] [String]$PolicyCategoryFilter,

[parameter] [string]$EvalMode

)

...

...

...

# Iterate through...

Apologies for the typo - it should be y.z

Thanks Gail I'll give that a try.

If I run the same EXEC msdb.dbo.sp_send_dbmail routine through SSMS only one Email is sent.

If I run this through a SQL task in SSIS I get three emails. However, I...

Yes I think that is the issue but am struggling to see why, as the Email task only seems to be executed once for each pass through the loop

Yes

Point taken re: first comment. We are looking to setup an A/G Group between two clustered SQL instances.

So this is not really supported?

Yes they are all in same filegroup.

After doing some more research I discovered that the data files are filled by the same amount if each file is the same size...