Often you face following error when you try to use the powershell for the first time.
File C:\Windows\system32\SQLServiceRecycle.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details.
At line:1 char:24
+ .\SQLServiceRecycle.ps1 <<<< + CategoryInfo : NotSpecified: (:) , PSSecurityException + FullyQualifiedErrorId : RuntimeException
The reason of this error is that the execution policy is not set correctly.
Run following command: GET-ExecutionPolicy
The result will be restricted.
Now to fix this set the execution policy to unrestricted as follows:
Now you can run the script without any hindrance.
INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
Online Powershell and SQL Classes @ http://tuitionaffordable.webstarts.com