Powershell

• Topics

  Started by

  Posts

  Last post

• how can i get Powershell

  to search stored procedures for server names? we have the list of server names, but not sure if we …

  drew.georgopulos

  2 replies

  10 years, 11 months ago

  By: drew.georgopulos

• Retrieve data and log file names from SQL database

  Hi, I'm trying to pull the logical and physical file names from sql server database using powershel…

  Robin35

  3 replies

  10 years, 12 months ago

  By: Orlando Colamatteo

• Problem copying .bak with "$" in file path/name (PS running in SQL job step)

  I'm using OLA's SQL JOBs to do my database maintenance. So far, I really like them; they're very ha…

  mstjean

  4 replies

  11 years ago

  By: Gary Varga

• Can't script the schema for a FK

  Hi, I use the below script to script out FKs in a database: #DECLARE TIMESTAMP FOR THE FILES $times…

  Roust_m

  4 replies

  11 years ago

  By: Roust_m

• Pass parameter into XML file using Powershell

  Hi, I have a project to automate SQL server restore.........use restore db's using third party tool…

  Robin35

  2 replies

  11 years ago

  By: Robin35

• French characters into SQL Server

  Hi all, I use Powershell to deploy DB scripts. In one script file, I have French accented character…

  schleep

  6 replies

  11 years ago

  By: AlreadyPicked

• Orphaned DB?

  So I am exploring PowerShell, and found a DB with .Databases that I can't see in sys.databases. I r…

  dkschill

  6 replies

  11 years ago

  By: dkschill

• INSERT statements containing regex as a string being read as regex

  I am attempting to run a sql script with 4 simple INSERT statements. Each of the 4 INSERTS is inse…

  hfxDBA

  2 replies

  11 years ago

  By: hfxDBA

• Risks/Best practices on execution policy

  While it would be easy to set the execution policy to unrestricted, or possibly set it to unrestric…

  Indianrock

  5 replies

  11 years, 1 month ago

  By: Indianrock

• Getting printers on a remote PC in a workgroup

  I'm trying to learn PowerShell. So I did a Get-Help Get-Printer -examples and saw that I can issue …

  Doctor Who 2

  5 replies

  11 years, 1 month ago

  By: Doctor Who 2

• collecting a count of errorlogs using posh

  Hi, I am running a script to collect a count of all errors in the current error log using smo, as b…

  Simon D Richards

  1 replies

  11 years, 2 months ago

  By: Simon D Richards

• How to pass a response to a .exe called by PoSh

  I'm calling an command line .exe from within a PoSh script. This is generating a hit Y for Yes / N …

  schleep

  5 replies

  11 years, 2 months ago

  By: Orlando Colamatteo

• Windows Batch, VBScript and PowerShell

  I have written tons of Windows Batch scripts and compiled VB6, however not as much VBScript. That s…

  Orlando Colamatteo

  2 replies

  11 years, 2 months ago

  By: Baguckis

• Invoke-Sqlcmd Count

  Hello, I searched for this on here and google and didn't see an exact answer to my question, so sor…

  Eric Zierdt

  1 replies

  11 years, 3 months ago

  By: Orlando Colamatteo

• Help me Error SSIS Error (Agent Service)

  An invalid reporting option was specified. Only E, W, I, C, D, P, V, and N are allowed Import Data…

  mai0165

  5 replies

  11 years, 3 months ago

  By: Koen Verbeeck