Powershell

• Topics

  Started by

  Posts

  Last post

• Need to gather the cluster server name for a SQL server service running on a node of a cluster

  Hello All, per a task I need to get the name of the Cluster name which is running on a Clustered no…

  rahulr.sharma

  11 replies

  14 years ago

  By: EdVassie

• Transfer DBs between SQL2K, SQL2K8

  Hi all, I'm having strange problems with the transfer. In SQL 2K, there are two views dbo.sysconstr…

  schleep

  16 replies

  14 years, 1 month ago

  By: schleep

• Scripting out sqlserver 2005 stored procedures?

  Hi there! On my local SQL Server 2k8 machine I'm able to use SQL Server Powershell to script out S…

  MissPukeyCow

  3 replies

  14 years, 1 month ago

  By: Grant Fritchey

• Get hard drive information of a remote server using Powershell 1,0

  ello All, I wanted to know if there is a method that I can use to get the hard drive information of…

  rahulr.sharma

  5 replies

  14 years, 1 month ago

  By: chrisn-585491

• 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

  14 years, 1 month 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

  14 years, 1 month 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

  14 years, 1 month 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

  14 years, 2 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

  14 years, 2 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

  14 years, 3 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

  14 years, 3 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

  14 years, 3 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

  14 years, 3 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

  14 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

  14 years, 3 months ago

  By: Mike - CI