Close this Advertisement

SQL Advisor

Article no longer available

Article is no longer available

  • 03/03/2011

Editor's Note: Due to the comments pointing out the many inaccuracies in the article, we have pulled it from the site.

Our apologies to the author, as he had written it for another 1105 Media property nearly two years ago, about six months after the release of SQL Server 2008 (prior to any service packs). Many of the inaccuracies are due to references to that older version, including links that have died since publication of the article, as well as errors introduced upon its recent republication. So we take full blame for publishing it before checking on the timeliness of the information. 

We fully expect to republish a newer, more timely article on this topic in the near future. Sorry for the inconvenience.

If you'd like to discuss this article or provide feedback, write to me, Michael Domingo, at mdomingo@1105media.com.

Reader Comments:

Wed, Apr 6, 2011 Thomas Lee UK

I hope that this article can be pulled and re-written to be correct. And until/unless this happens, I hope readers will actually look at these comments to see the errors contained.

Wed, Apr 6, 2011

The inaccuracies in this article are laughable.

Tue, Apr 5, 2011 bass_player

That should be Get-Command without the "s." You can also check out this article on Introduction to Windows PowerShell for the SQL Server DBA http://www.mssqltips.com/tip.asp?tip=1680

Tue, Apr 5, 2011 Max Trinidad

To the author of this article... Part of the information given today is misleading. First, there's no PowerShell v2 CTP available. Also, you need to remove both link provided under: 1."Click here for a blog post outlining what's Available" and 2. "Click here for the direct link to the download". They both point to old blog post that shouldn't be use and both URL are not valid. instead, use the URL to point to the KB article because it has everything needed to get PowerShell v2 RTM. Please, we need to make sure the information given is accurate in order to avoid confusion. Thanks.

Tue, Apr 5, 2011 Max Trinidad

PowerShell V2 IS ALREADY included in Windows 7 and Windows Server 2008 R2. For other OS's such as Windows XP, Vista, and Windows 2008 SP1 the you need to use the KB article 968930. Also, this article fails to mention about using Get-Command when running SQLPS.exe only works in SQL Server 2008 SP1 and not in R2. This issue will be corrected in with the next SQL Server R2 SP1 and is fine in SQL Denali. It's very important to everyone to understand the there's no PowerShell CTP available, it's RTM V2 thru the MS KB article previously mention.

Tue, Mar 22, 2011 Geri Reshef http://About.me/GeriReshef

I'm Trying to use PowerShell, it is installed, but it returns an error message. A Copy & Paste from my Cmd window:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\me>cd\

C:\>Powershell
Windows PowerShell
Copyright (C) 2006 Microsoft Corporation. All rights reserved.

PS C:\> get-commands
The term 'get-commands' is not recognized as a cmdlet, function, operable progr
am, or script file. Verify the term and try again.
At line:1 char:12
+ get-commands

Fri, Mar 11, 2011 Richard Giles

You inaccurately reported above that PowerShell v2 was only available for Win7 and Win2008 R2. This is not true. Use http://support.microsoft.com/kb/968930 to locate all Windows Manage Framework Core packages for PowerShell v2 and WinRM 2.0.

Add Your Comment Now:

Your Name:(optional)
Your Email:(optional)
Your Location:(optional)
Comment:
Please type the letters/numbers you see above