Powershell

• Topics

  Started by

  Posts

  Last post

• MAXCHARLENGTH in SQL SMO

  I export blob data using invoke SQL with the parameters -MaxCharLength and -MaxBinaryLength&nb…

  gwellbrock

  3 replies

  8 years, 5 months ago

  By: gwellbrock

• 'invoke-sqlcmd' is not recognized as the name of a cmdlet

  Good day -  I have been writing Powershell scripts to use Invoke-sqlcmd to complete some data …

  CoryEllingson

  7 replies

  8 years, 5 months ago

  By: Thom A

• PowerShell via SQL Agent 2016

  Hey all, I can run my PS script just fine via the command line. Yet, when I setup an Agent job for …

  Adam Bean

  5 replies

  8 years, 5 months ago

  By: Gary Varga

• SQL Policy Management - Invoke-PolicyEvaluation - remote policy file path

  Hi, I'm trying to call a number of XML SQL Management Policy files using a remote network path e.g.…

  pgraves

  5 replies

  8 years, 5 months ago

  By: frederico_fonseca

• Alternative to invoke-sqlcmd cmdlet - SMO

  Hi Team, I am trying to retrieve sql data using powershell code - invoke-sqlcmd. Invoke-sqlcmd is f…

  chinna.sp3025

  4 replies

  8 years, 5 months ago

  By: Gary Varga

• EXEC xp_cmdshell 'Powershell.exe

  HI,     Have a problem not sure if its permission issue or something else, any suggestion…

  rajju_vini

  2 replies

  8 years, 6 months ago

  By: Mr. Brian Gale

• Powershell formatting help - convert-html commandlet

  Hi Experts, I need some formatting help in powershell using convert-html commandlet. Basically, h…

  vsamantha35

  6 replies

  8 years, 6 months ago

  By: Gary Varga

• Load data using powershell

  Hi Poweshell Gurus I am a power shell newbie , looking to import SQL server version information of …

  pshrestha4

  5 replies

  8 years, 6 months ago

  By: Henry B. Stinson

• Poweshell script to script out jobs, databases, users, linked servers, logins, roles, alerts, etc from a list of servers

  create a c:\servers.txt file with list of servers and copy the following into a file .ps1 enjoy fun…

  genehunter29009

  12 replies

  8 years, 6 months ago

  By: Lowell

• how to pass the result of compare-object to be use in if else statement

  hi all,basically i am comparing 2 .csv files and output the result to another .csv file.i can't see…

  flaskvacuum

  8 replies

  8 years, 6 months ago

  By: flaskvacuum

• PowerShell Script Help

  I am looking for power-shell script which does QA checks on MSSQL database based on the parameters …

  Nani_01

  1 replies

  8 years, 7 months ago

  By: Gary Varga

• SQL SERVER PS. Retreive Databases and Database Roles from instances

  I will like to Retrieve Databases  and  Database Roles from many instances in the do…

  KSQLDBA

  2 replies

  8 years, 7 months ago

  By: T Michael Herring

• parsing records with empty spaces

  I have text  data in following format ServerName      Server.db …

  ebooklub

  24 replies

  8 years, 7 months ago

  By: ebooklub

• pipe result to a .csv or .txt files

  Hi All,i find it hard to pick up powershell...need some help here.... .i have some result as below:…

  flaskvacuum

  4 replies

  8 years, 7 months ago

  By: Gary Varga

• Powershell vs Sqlcmd

  Hi there, I'm wondering if anyone can explain whether I should be using Powershell instead of Sqlcm…

  jts2013

  16 replies

  8 years, 8 months ago

  By: Jeff Moden