sqlps Questions
6
I have sqlcmd.exe from both SQLServer 2008 and SQLServer 2012:
PS C:\> Get-Command sqlcmd.exe
Definition
----------
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE
C:\Program F...
Revkah asked 13/6, 2013 at 8:42
3
I installed ms sql server with chocolatey:
choco install SQLServer2012DeveloperEditionWithSP1 -y -f -source 'http://choco.developers.tcpl.ca/chocolatey' -c "$env:WINDIR\temp"
SQL seems t...
Baez asked 2/5, 2017 at 22:58
6
Solved
I trying to restore a database by using the Restore-SqlDatabase cmdlet. I need to relocate the files but I'm getting the following errror
Restore-SqlDatabase : Cannot bind parameter 'RelocateFile'...
Aileenailene asked 15/10, 2014 at 7:58
3
Windows 7 workstation
POSH 3.0
SS 2012 SP1
Abstract:
Developer 1 cannot run Invoke-SQLCmd
Developer 2 with similar SS Client tools installation can run Invoke-SQLCmd
Developer 1 cannot run Impor...
Kolodgie asked 16/10, 2015 at 14:19
2
Solved
Previously working with PowerShell 3. Upgraded to PowerShell 4 and uninstalled it as facing error stated.
Import-Module : The specified module 'SQLPS' was not loaded because no valid module file w...
Parmesan asked 30/10, 2015 at 5:26
1
Solved
I am trying to script User Mapping for different Login accounts. I have scripted the creation of users and individual server roles, but I can't figure out how to set User Mapping with Powershell, I...
Nolitta asked 27/8, 2013 at 14:44
1
© 2022 - 2024 — McMap. All rights reserved.