Powershell

• Topics

  Started by

  Posts

  Last post

• Getting started with Powershell

  Hi all I'm just getting started with PowerShell and following the series by Ben Miller here.  …

  richardmgreen1

  10 replies

  7 years, 10 months ago

  By: SQLPirate

• invoke-sqlcmd and stolen single user session

  HiI run following sql script (part of script file) file with invoke-sqlcmd:...if db_id('xxx') is no…

  veepee78

  18 replies

  7 years, 10 months ago

  By: Steve Jones - SSC Editor

• using New-AzureRmSqlDatabaseImport for importing database in azure sql database

  Hi all, I am trying to find out when using the following New-AzureRmSqlDatabaseImport cmdlet t…

  BoobyB

  2 replies

  7 years, 10 months ago

  By: BoobyB

• power my PS script to automatically connect via SQL authentication and execute the command

  Hi ,I have an working PS script that works via windows authentication so it appears. I have a speci…

  ebenraja

  2 replies

  7 years, 11 months ago

  By: ebenraja

• add filename extension

  I found this script online and would like to add a datestamp to the file.Schedule this to run every…

  mtz676

  1 replies

  7 years, 11 months ago

  By: Johan Bijnens

• Enumerations in PoSh prior to V5

  I'm trying to create an enum of our SQL ServersAdd-Type -TypeDefinition @" public enum OurServ…

  schleep

  4 replies

  7 years, 11 months ago

  By: schleep

• Powershell to get Results and Messages in SSMS inquiry

  I have a powershell script that will execute a query on a database that has Replication. $QueryPath…

  yhandz_21

  6 replies

  7 years, 11 months ago

  By: yhandz_21

• Group-object

  This should be simple, but I'm having trouble with suming values across groups: $a = @()$b = New-Ob…

  schleep

  1 replies

  8 years ago

  By: schleep

• Install SQL Server Named Instance using silent install PowerShell

  HiDoes anyone works on SQL Server Named install using PowerShell using .ini files?If you have any r…

  SQL_Hunt

  6 replies

  8 years ago

  By: SQL_Hunt

• Exception calling "ScriptTransfer" with "0" argument(s): "Script transfer failed. "

  Hello, while running this script, getting error -Exception calling "ScriptTransfer" with "0" argume…

  SQL_Hunt

  2 replies

  8 years ago

  By: SQL_Hunt

• Error to Retrieve DB status

  Hi All,Could someone correct the error messages in this PowerShell script used to retrieve DB …

  DBA_007

  1 replies

  8 years ago

  By: Gazareth

• Default values set for $param in advanced function

  How can I specify a list of values for an advanced function?For example, I want to write a function…

  schleep

  1 replies

  8 years ago

  By: schleep

• Powershell connecting to multiple instances

  I am new to Powershell and I am currently trying to figure out why the below is not returning the s…

  SQLAssAS

  2 replies

  8 years ago

  By: SQLAssAS

• Parameters with prompts

  Hi all I'm new to Powershell and Google didn't turn up anything useful (or that I could get working…

  richardmgreen1

  1 replies

  8 years, 1 month ago

  By: bruce 1565

• Powershell script transfers entire directory?

  I've got a powershell script I'm using to send one file via SFTP. The only problem? It's copying ev…

  Brandie Tarvin

  13 replies

  8 years, 1 month ago

  By: Brandie Tarvin