SQL Server PowerShell cannot find path error

Question

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?

Answer 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