PowerShell for Windows Admins

Sep 10 2013   1:20PM GMT

Loading the SQLPS module

Richard Siddaway Richard Siddaway Profile: Richard Siddaway

Loading the SQLPS module gives you quick access to the sql cmdlets, sql provider and the SMO assemblies. It also, infuriatingly, moves your location into the sql provider.

I (really) * (lots ) hate things that assume what I want to do.

You can use PowerShell to reverse this annoying, and arrogant action:


Import-Module SQLPS


Will get you back where you were.

SQLPS is slowly becoming a civilised member of the PowerShell eco-system especially when compared to its first incarnation. A few more versions and it might behave properly.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: