Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Powershell path not found

Am I missing a library?

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

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
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.