Powershell

• Topics

  Started by

  Posts

  Last post

• PowerShell Script to determine if database is online/offline

  I have created a powershell script to loop through a file of servernames listing each database and …

  Brandon Carl Goodman

  2 replies

  12 years, 8 months ago

  By: kstjacques

• Invoke-Sqlcmd and Transactions

  Our legacy process for upgrading our product's databases is built around the use of SQLCMD. We have…

  Andrew Schickedanz

  2 replies

  12 years, 8 months ago

  By: Andrew Schickedanz

• 2005 agent job - powershell job step

  Hi All, I'm a newbie with powershell so i apologise if i'm making any really basic mistakes here or…

  DBANewbie

  4 replies

  12 years, 8 months ago

  By: MissPukeyCow

• How to Parse .ini File into PowerShell Variable(s)

  I have the following .ini file (named metrics.ini) containing a single record, but it may have more…

  shew

  1 replies

  12 years, 8 months ago

  By: shew

• Get-WmiObject -computer $srv -Class Win32_LogicalDisk –filter "DriveType=3"

  hello, I run this command for a remote computer : Get-WmiObject -computer $srv -Class Win32_Logical…

  Aviad C.

  1 replies

  12 years, 9 months ago

  By: rahulr.sharma

• Invoke-PolicyEvaluation and -TargetExpression

  hello I have set up a condition and policy to check if datafiles have a @GrowthType of KB. This wo…

  iainthepitman

  1 replies

  12 years, 10 months ago

  By: AllenMWhite

• use Powershell to input files to MS SQL Server?

  I'm fairly new to Powershell and have run stuck on this. We have almost a hundred scripts that we l…

  ddonck

  5 replies

  12 years, 10 months ago

  By: Artem Ervits (@dbist)

• Set Objects of a SMO variable

  Hello All, What I am trying to do here is gather the SQL Server Jobs running on a SQL server and th…

  rahulr.sharma

  2 replies

  12 years, 10 months ago

  By: rahulr.sharma

• Tables[tablename] returning $NULL

  Hi All, With the following code $dts = $db.Tables returns the array of table names, but $dtn = $db.…

  geedeearr

  1 replies

  12 years, 10 months ago

  By: geedeearr

• 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

  12 years, 10 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

  12 years, 10 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

  12 years, 10 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

  12 years, 10 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

  12 years, 10 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

  12 years, 10 months ago

  By: schleep