The FQDN didn't change anything.   I changed Remove-Item to OutFile -FilePath C:\Test.txt  but the file comes up blank.

Yes, but several caveats. The problem with the msdb operator roles is that they grant rights to the user to do these things on ALL Agent Jobs, not only the...

I found a better answer:

invoke-SqlCmd -InputFile "C:\DBAScripts\Script.sql" -ServerInstance XXXX -Database XXXX -Verbose 4>  "F:\OutputPath\OutputScript.sql"

See https://sqlnotesfromtheunderground.wordpress.com/2015/09/09/powershell-outputting-a-sql-server-query-result-from-the-message-tab/

• This reply was modified 4 years, 11 months ago by  dan-572483.

I see I can also SELECT * from sys.dm_exec_connenctions where encrypt_option = 'TRUE' and join it to sysprocesses to get the database names.

Some of clusters have multiple instances\roles, so it seems faster to pause & resume the passive nodes instead, and since this is every machine in that datacenter we'll have a...

The Trustworthy setting was it. Thank you.

Can you do a search like that in TFS?

I found the answer to my question.  Yes, in SSDT 2015 you can set the Project properties down to SQL 2012, which means you can deploy to a SQL 2012 Integration...

Wait!  I thought I read that the current version of SSDT can develop for SQL 2005, 2008 and 2012 Integration Server instances.

Is that not true?  Do we need...

Arrg, We were recently instructed to install Visual Studio 2017 Pro, which doesn't have support for SSIS (yet)...

Like many application this particular application has a database connection config screen with a "Test Connection" button.   With the service account in the DB Owner group for it's database I tried several...

When I read threads like this I realize that different people have different learning styles, and what works for one person may not work well for another. Maybe someone will...

How about with XtremIO or similar flash storage?  That's what the server I'm building will have access to.

The IT Training site https://www.pluralsight.com/  includes tests you can take that rate your proficiency and recommend training videos on the areas you would benefit learning more on.   That's a great...

This was the quick & easy solution. I assumed that an identity column had to be specified before you start adding records. No, it will create them on existing...