This works but sends an email for every table listed in query .. It's the "For Each" ... How can I issue just 1 email  and list all of the

results...

Trying to goggle now to find eamples based upon what I have as Input above.

Thanks for all comments and suggestions.

foreach ($Row in $DataSet.Tables[0].Rows)
{
write-host "Processing" $Row.Column1


$Capuretbl = $Row.Column1


$queryData = "
          Insert into dba_usage.dbo.Tbl_Alerts...

I changed this piece:

select table_schema+'.'+table_name from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%DateStored%' order by TABLE_NAME

It's throwing up the error:  It's getting the correct schema owner and Table ...

Exception calling "Fill" with...

I ran a test with dbo schema, and it works great, but these tables I'm querying have a different schema owner.

Just something I wanted to try to use PoSh..

ANy ideas on the schema owner issue ?

Thanks everyone.

How do I get around schema owner <> dbo..  ?

Thanks.

This is what I came up with.

$server = "sqltest"
$database = "dbastuff"
$tablequery = "select table_name from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%DateStored%' order by TABLE_NAME"
 
#Delcare Connection Variables
$connectionTemplate =...

Sorry no tables that are queried will change.. this is a static mature environment ..

I would manually update the file from a folder, and this list of tables won't change. The alert will run daily maybe every x hours..

We had an issue where table...

Thanks Thom for the SQL piece.

This DB is running on a SQL2012 box

I would use a File as a list.

Thx.

Was trying to keep it in script if possible.

Thx.

yeah thinking the script in PS so if needed updated adding more tables to list would be easy to update script rather than having someone having to use SSMS to update...