Change this line:

foreach($Value in $TargetDataSet.Tables[0])

To this:

foreach($Value in $TargetDataSet.Tables[0].Rows)

And then the "$Value" contains each row, then you can pass each value to the specified property by referring to it as "variable.columnName"....

The switch you are referring to is for sqlcmd. Being that your code outputs a table (dataset) there is no true way of removing it just with a switch.

You could...

It all works fine if used properly...

Blogged about the issue here[/url] and what you can do to improve it.

I actually wrote this up in a few blog post here[/url] and here[/url].

The link provided in the previous post is the link that takes you to the latest release...

The method used for that script has the objects associated with the table included in the table script, just as it would if you scripted the object in SSMS. If...

Availability Groups is mirroring with new features.

Just because the server is a secondary replica does not mean the database in question is part of the AG, unless you verified that...

Here is a tip that walks through the setup using PBM for column data types:

https://www.mssqltips.com/sqlservertip/1993/find-all-sql-server-columns-of-a-specific-data-type-using-policy-based-management/[/url]

Properties are empty because you are not connected to the instance. You cannot pass the port number to SMO as you...

I think registration is open until the Friday before the event. If you go to the event page and do not see a registration button or option I would expect...

You need to audit for failed logins using "Audit Login Failed".

You might also check the default trace if the event occurred recently it should have captured it in that file...

chuck.forbes (1/14/2016)

---

I'm probably wrong, being so new to SQL Server and Extended Events, but the "event stream" target seems to only supply information if you're watching the live viewer....

Overall your session is missing a target. If you do not provide one not sure what target it defaults to.

Will also note though that opening the Live Data Viewer...

Nope

Pluralsight ($30 USD a month is pretty cheap, not sure what that converts to your area) is best bet to get current self-paced training, anything by Stacia Misner Varga is...