I'm new to SQLPSX, but in trying to follow an example on someones site:
Import-Module sqlmaint
$SQLServer = "localhost"
$SQLDBName = "work"
$SQLQuery = "SELECT * FROM dbo.server"
$database = Get-...
Id #8 | Release:
None
| Updated: May 2 at 7:51 PM by zierde01 | Created: May 2 at 7:50 PM by zierde01
There are two cmdlets/functiosn with unapproved verb names:
Decode-SQLName
Encode-SQLName
To see this, after loading SQLPS, do this from a PowerShell prompt:
Import-Modue SQLPS -Verbose -For...
Id #7 | Release:
None
| Updated: Feb 25 at 9:21 AM by tfl | Created: Feb 25 at 9:16 AM by tfl
See http://social.technet.microsoft.com/Forums/en/sqlkjmanageability/thread/be63367b-306e-4ab3-a48b-b0bb8be745ee
Need to add a type file to module in order to avoid add-member issue.
Id #6 | Release:
None
| Updated: Feb 11 at 3:02 PM by cmille19 | Created: Feb 11 at 3: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:
None
| Updated: Dec 6, 2012 at 8:15 AM by ALZDBA | Created: Dec 6, 2012 at 8: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:
-On...
Id #3 | Release:
None
| Updated: Nov 4, 2012 at 6:37 PM by Bernd_K | Created: Nov 4, 2012 at 6: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:
None
| Updated: Sep 26, 2012 at 10:38 AM by josepmv | Created: Sep 26, 2012 at 10:38 AM by josepmv