Recently i started using SQLPSX, It is a must to have tool.
I have sql job which executes a powershell script includes this extension. The objective of the job is successfully. ...
Id #9 | Release:
| Updated: Oct 21 at 10:45 PM by vthelu | Created: Oct 15 at 9:09 PM by vthelu
I'm new to SQLPSX, but in trying to follow an example on someones site:
$SQLServer = "localhost"
$SQLDBName = "work"
$SQLQuery = "SELECT * FROM dbo.server"
$database = Get-...
Id #8 | Release:
| Updated: May 2 at 8:51 PM by zierde01 | Created: May 2 at 8:50 PM by zierde01
There are two cmdlets/functiosn with unapproved verb names:
To see this, after loading SQLPS, do this from a PowerShell prompt:
Import-Modue SQLPS -Verbose -For...
Id #7 | Release:
| Updated: Sep 19 at 1:25 AM by MikeShepard | Created: Feb 25 at 10:16 AM by tfl
Need to add a type file to module in order to avoid add-member issue.
Id #6 | Release:
| Updated: Feb 11 at 4:02 PM by cmille19 | Created: Feb 11 at 4:02 PM by cmille19
I have this fresh install of Win7 x64 with only a client install ( except the add-in s ) of SQL2012.
(My PowerGUI has been configured to actually use Powershell V3.0)
Now, when I load SQLPSx it ...
Id #5 | Release:
| Updated: Dec 6, 2012 at 9:15 AM by ALZDBA | Created: Dec 6, 2012 at 9:15 AM by ALZDBA
In SQLISE when I open the Connect dialog on Windows 7 64-bit with PowerShell V3, I get Property "Visibility" not found. As workaround I did the following modification to Get-ConnectionInfo.ps1:
Id #3 | Release:
| Updated: Nov 4, 2012 at 7:37 PM by Bernd_K | Created: Nov 4, 2012 at 7:37 PM by Bernd_K
I've had an issue with SQLMaint module when with -Action "BKP_LOG" but it could have happened with other backup options. I do a transaction log backup every 15 minutes. When testing the restore pla...
Id #2 | Release:
| Updated: Sep 26, 2012 at 11:38 AM by josepmv | Created: Sep 26, 2012 at 11:38 AM by josepmv