Powershell

• Topics

  Started by

  Posts

  Last post

• Calling a Stored Procedure with Output Parameters

  I have another PowerShell newbie question. I want to run a stored procedure from a PowerShell scri…

  imani_technology

  1 replies

  8 years, 11 months ago

  By: Gary Varga

• run sql server unattended setup on remote host using powershell

  running Enter-PSSession -ComputerName MyServer001 -Credential pricing\dba connected at [MyServer001…

  ebooklub

  5 replies

  9 years ago

  By: philcart

• Edit the Directory physical path Location for Applications Under Default Website

  Hi, I'm currently looking for a way to amend applications physical paths through power-shell i…

  Suth

  5 replies

  9 years ago

  By: Gary Varga

• Invoke-ASCMD - Passing values to the XMLA file not working

  I need to create a cmd file to backup Analysis Service Database. Because my SQL Server 2014 does no…

  smiller9270

  2 replies

  9 years ago

  By: blackbinary

• Autoalert if SQLAgent stops

  I have this piece of powershell code which sends out an email when executed in a SQL job or run in …

  mtz676

  5 replies

  9 years ago

  By: blackbinary

• Export Output/Log Info to .CSV

  Right now, the output of my script looks this: Microsoft (R) SQL Server Execute Package Utility Ver…

  imani_technology

  9 replies

  9 years ago

  By: blackbinary

• Got what I need, but perhaps a more elegant solution is out there. Looping through SQL filegroups to get Maxsize.

  Hey PoSh experts, So I need to get the max size setting of all SQL databases in the primary filegro…

  Duran

  5 replies

  9 years ago

  By: Duran

• Easy piece of code just doesnt bloody work.

  Sounds like a headline from the onion. All I want to do is add a new database role to a database an…

  Duran

  8 replies

  9 years ago

  By: Duran

• Need help to get Disk I/O of all disks in a server

  Hello Friends, Can someone please give me the command to get me the Disk name and Disk I/O on a win…

  Mac1986

  1 replies

  9 years ago

  By: Leonard Rutkowski

• how connect to sql server as different user using powershell ?

  Example $instanceName ="Host001\Server1,14002" $AppName = "$($ENV:computername.ToString())_$(($MyI…

  ebooklub

  3 replies

  9 years ago

  By: Gary Varga

• Export Large Tables To CSV Slow

  Hi there I have written a PS script to export a batch of tables listed in a .txt file to CSV: $serv…

  shindle 17293

  3 replies

  9 years ago

  By: shindle 17293

• Is there a way to check stored procs affected by change to a view?

  I'm trying to see which stored procs (and functions) might be affected by my having added a column …

  schleep

  12 replies

  9 years, 1 month ago

  By: schleep

• Extract output from central management servers into a table

  This one has my head spinning. I would like to run a query on all of the servers registered in the …

  PHXHoward

  8 replies

  9 years, 1 month ago

  By: PHXHoward

• Powershell script for SSIS 2012 build and deployment

  HI All, I need Powershell script sample for Build and Deployment of SSIS 2012 packages . we are u…

  latitiacasta

  9 replies

  9 years, 1 month ago

  By: Gary Varga

• please help me to send mail to all as below script output

  $ServerList = Get-Content "D:\ServerList.txt" $OutputFile = "D:\Output.htm" $HTML = '<style type…

  rajadadi

  2 replies

  9 years, 1 month ago

  By: Leonard Rutkowski