Powershell

• Topics

  Started by

  Posts

  Last post

• Load data from PowerShell

  Dear all, I am new to PowerShell and SQLServer2008. What I am trying to do is, query SQLServer2008 …

  harby_sandhu

  1 replies

  13 years, 3 months ago

  By: Mike - CI

• dtsx+powershell

  hi, mybe anyone know if there is a object in powershell for excaute DTSX package.

  Aviad C.

  3 replies

  13 years, 3 months ago

  By: Mike - CI

• SQL Agent Job Step message

  Hi experts, I plan to set up a script that will monitor SQL Agent jobs and if the their status is f…

  Mr. Holio

  3 replies

  13 years, 3 months ago

  By: Mike - CI

• Get version details of multiple SQL server's

  Hello All, I have a task of querying up some 400+ SQL server and getting the Version details of the…

  rahulr.sharma

  1 replies

  13 years, 3 months ago

  By: Mike - CI

• load::assembly

  hi, I try to use the object "Microsoft.SqlServer.ManagedDTS", and for that I undetstand that I need…

  Aviad C.

  1 replies

  13 years, 3 months ago

  By: Fish Man

• Transfer DB using Powershell

  I'm trying to copy objects and data using the PS Transfer object. I keep getting an error on sp_gra…

  schleep

  1 replies

  13 years, 3 months ago

  By: schleep

• Odd Powershell/SMO behaviour with error handling

  Hi folks I hope someone can shed some light on this. I had a powershell v2.0 script that looped thr…

  mazzz

  2 replies

  13 years, 3 months ago

  By: mazzz

• Write results to table on Central Management Server

  Hi everyone. Hope you are having a great day. I would love some help on this PowerShell query. Wh…

  PHXHoward

  1 replies

  13 years, 4 months ago

  By: PHXHoward

• Powershell run specific scripts against each database

  Hi i am new to Powershell and was hoping someone could help Scenario: I have one sql script per dat…

  schwizla

  10 replies

  13 years, 4 months ago

  By: schwizla

• Error when configuring SQL job step to execute powershell script

  I'm trying to create a SQL-job step that will be executing a powershell script. In the Job Step Pro…

  Marios Philippopoulos

  3 replies

  13 years, 4 months ago

  By: mazzz

• trying to send alert in application log

  looking to catch the dreaded 14151 errors on replication and below code is not sending an alert. in…

  alen teplitsky

  2 replies

  13 years, 5 months ago

  By: alen teplitsky

• help with mangeddts

  hi, I try to create this object, but I Had error : $obj= new-object Microsoft.SQLServer.ManagedDTS …

  Aviad C.

  2 replies

  13 years, 6 months ago

  By: Grant Fritchey

• New to Powershell and want to learn it

  Hi all, I am new to powershell and learning it to make mylife easy to work as SQL DBA, can you plea…

  veeren4urs

  2 replies

  13 years, 6 months ago

  By: veeren4urs

• Checking owner of SQL files

  For those that work with miltary or any government agency you have to deal with DoD STIGs (basic se…

  Shawn Melton

  3 replies

  13 years, 6 months ago

  By: Jeffrey Williams

• SMO ScriptingOptions - ScriptBatchTerminator

  I am trying to script database objects and include a Batch Termintor (GO). I have loaded the SMO.Sc…

  MG-148046

  4 replies

  13 years, 7 months ago

  By: MG-148046