SQL Server PowerShell cannot find path error
I cannot use Set-Location
to change to a database. I have loaded the SQL Server snapins. I can use Set-Location
to get to SQL\Localhost\SQLEXPRESS\
, and I can show the paths under the server node with Get-ChildItem
. However, if I try to change to a known database on my machine, the Set-Location
call fails.
Am I missing a library?
Solution 1:
Finally found the answer on MSDN Social here. It's not enough to simply load the PowerShell plugins. You have a few more commands that also need to be run. (Solution source.)
Push-Location
cd $sqlpsPath
Add-PSSnapin SqlServerCmdletSnapin100
Add-PSSnapin SqlServerProviderSnapin100
Update-TypeData -PrependPath SQLProvider.Types.ps1xml
update-FormatData -prependpath SQLProvider.Format.ps1xml
Pop-Location