Powershell

• Topics

  Started by

  Posts

  Last post

• Powershell syntax error in SQL server Agent job

  Hi, I am running below code, running fine in PS terminal and ISE.  When I am running it from SQL a…

  sdbjakeer

  3 replies

  2 weeks, 1 day ago

  By: Jeffrey Williams

• PS script works in ISE but fails in SQL JOB step with a syntax error

  I need to copy a subset of rows from a table on a (sql2016) server, to a table on a (sql2008r2) ser…

  mstjean

  6 replies

  2 weeks, 1 day ago

  By: Jeffrey Williams

• Using powershell to strip RTF tags and return text.

  Hi, We've been looking to pull the text from a table in a vendor DB that stores in RTF format. I fo…

  PretendDBA

  2 replies

  2 weeks, 2 days ago

  By: PretendDBA

• Get data from last line and merge into data stream before removing

  This script reads thru a file and removes the last line, but before it does that can I grab a value…

  Bruin

  3 replies

  1 month, 3 weeks ago

  By: Bruin

• Server Documentation

  I'm looking for a powershell script to gather the following information from my server that has mul…

  rr_littletons

  1 replies

  1 month, 3 weeks ago

  By: rr_littletons

• Find Sheet name if Not exist stop and email issue

  I have a process that uses an xcel file and looks for the default Sheet1. There are times when some…

  Bruin

  4 replies

  1 month, 3 weeks ago

  By: Bruin

• when use dbachecks, it has error: unable to find type [Pester.outputtypes]

  hi there: When I type invoke-dbcCheck, it pops up error below: Unable to find type [Pester.otuputTy…

  huishi.ca

  1 replies

  2 months ago

  By: Ant-Green

• Powershell script multiple output into SSIS variables

  Hi Guys, How can I store multiple output results from Powershell to variables in SSIS? Thanks. …

  rocky_498

  4 replies

  2 months, 2 weeks ago

  By: rocky_498

• Scanning to find sql instances/servers

  We use MAPS tool to scan through our domain and then list out our sql servers/instances. How can th…

  mtz676

  1 replies

  2 months, 3 weeks ago

  By: Michael L John

• How to check if the file exists in S3 bucket.

  Hi, I am trying to build a script to copy sql backups to an S3 bucket.  The structure of the folde…

  Roust_m

  7 replies

  4 months, 2 weeks ago

  By: Steve Jones - SSC Editor

• remove lines from flat file with no header

  I have a file that has a delimiter of bar (|) and has no headers. I need a way to remove bad data r…

  Bruin

  4 replies

  4 months, 2 weeks ago

  By: Jeffrey Williams

• Need Powershell script to change SQL Server service password

  Need sample Powershell script to change PWDS for SQL Server services (on many SQL Servers). We need…

  Express12

  1 replies

  4 months, 2 weeks ago

  By: frederico_fonseca

• Remove-Item quirks

  I am trying to write a script in Powerhsell to run in SQL Agent to maintain a backup archive.  We …

  dan-572483

  3 replies

  5 months, 1 week ago

  By: Mr. Brian Gale

• run mssql stored procedure from PS script and capture output

  Can someone share a PS script that will execute a mssql stored procedure and capture all of the out…

  Bruin

  11 replies

  5 months, 3 weeks ago

  By: frederico_fonseca

• copy file from sharepoint site to Azure storage

  I'm looking to transfer files from sharepoint site to Azure storage. I cannot use Logic apps or Flo…

  khushbu

  1 replies

  7 months, 3 weeks ago

  By: khushbu