August 12, 2014 at 4:57 pm
I have started going though the Stairway to Powershell tutorial on this site at http://www.sqlservercentral.com/stairway/91327/ but I am practicing on SQL 2012 while this tutorial is written for 2008 R2
On Lesson 2 (http://www.sqlservercentral.com/articles/Stairway+Series/91442/) it says there are a some components that need to be installed, SQL CLR Types, Shared Management Objects (SMO) and PowerShell Objects, and that if you have management tools you should already have them.
Well, I do have Management Tools for SQL 2012, but I don't seem to have these components. When I run Add-PSSnapin SqlServerCmdletSnapin100 I get an error saying the snap-in is not installed. I looked at the Microsoft download site and SQL 2012 versions of these components don't seem to be available.
What do I need to do to continue this tutorial using SQL 2012?
August 13, 2014 at 3:50 pm
I found the answer.
If you have SQL 2012 Management Tools installed, the command is
Import-Module "sqlps" -DisableNameChecking
The command switch disables a warning message.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply