Powershell

• Topics

  Started by

  Posts

  Last post

• Wanted to check good / alive SQL Servers through script.

  Hi, I want to extract the list of good servers where the SQL Server services are running to execute…

  SQL_Hunt

  10 replies

  10 years, 10 months ago

  By: Phil Factor

• File transfer failing with no error returned

  Hi all- I have a PS script that I use to transfer files from our data center to our corporate locat…

  Rogman

  11 replies

  10 years, 10 months ago

  By: Gary Varga

• Ideas to monitor file copying progress for automated script

  I have a PS script that runs on a schedule. This process is automated and the app that calls the PS…

  podmate

  1 replies

  10 years, 10 months ago

  By: Gary Varga

• Difference between ISE vs command line and out of memory

  I'm having a small problem. I downloaded a Powershell script that would allow me to deploy SSRS re…

  dpoquette

  5 replies

  10 years, 11 months ago

  By: Jeff Moden

• Output message from invoke-sqlcmd required

  I am using powershell to run a .sql file and I need to log the out put to a txt or csv file. Troubl…

  Ian_McCann

  5 replies

  10 years, 11 months ago

  By: Gary Varga

• Query AD - Script Out of memory

  I have a problem with a script to query ActDir. I have found some code to search what I need, but …

  T2000

  9 replies

  10 years, 12 months ago

  By: schleep

• Script to change SQL Server and SQL Server Service Logins.

  I need a Script to change SQL Server and SQL Server Service Logins. Does any one have a script to d…

  Welsh Corgi

  6 replies

  11 years ago

  By: Welsh Corgi

• Server 2003 powershell

  What version of powershell ships with Windows Server 2003? There is an exception to every rule, exc…

  SQLHeap

  3 replies

  11 years ago

  By: drott

• Connecting to remote server using powershell subtype

  Hi All, Super newbie to powershell and I am on Day 1 of learning..i am trying to configure a SQL Se…

  msandico 57892

  4 replies

  11 years ago

  By: Drenlin

• Restore with relocate database files location in powershell

  Please help me to modify this script as relocate database files location means like with move ... t…

  rajadadi

  2 replies

  11 years ago

  By: Leonard Rutkowski

• PowerShell Vulnerabilities

  I had an interesting conversation with one of our security folks yesterday about PowerShell vulnera…

  shew

  5 replies

  11 years, 1 month ago

  By: Gary Varga

• SQLPS (SQL Server 2012)

  I am starting to learn (work) with PowerShell. On my work laptop I have installed SQL Server 2012 …

  Lynn Pettis

  2 replies

  11 years, 1 month ago

  By: Gazareth

• email if no new files in last 2 days

  I have this code that works great if there is a new file in the last 23 hours. how can I adjust it …

  yanks10952

  5 replies

  11 years, 1 month ago

  By: Gary Varga

• SQLPS takes 30 minutes to import. How to fix it?

  Hey SSC, SQLPS on my workstation used to take around 30 seconds to import. Not exactly speed-of-tho…

  iainelder

  2 replies

  11 years, 1 month ago

  By: Cody Konior

• How to find number of columns returned from query in powershell

  I want to find out number of columns returned from a query in a powershell script. As we will be pa…

  Chand00

  15 replies

  11 years, 1 month ago

  By: Jeff Moden