Friday, 13 November 2020

Power Shell Script SQL

 

MVKSPA_DB_Script.ps1 cannot be loaded. The file 

D:\upload\MVKSPA\MVKSPA\DB\DBDesign\PowerShellScript\MVKSPA_DB_Script.ps1 is not digitally signed. You cannot run this 

script on the current system. For more information about running scripts and setting execution policy, see 

about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.





#Step 1: Check SQLServer Powershell module exist in your system or not , you can find using below command.

Get-module  SQLServer -ListAvailable



#Step 2: If SQL server module is not exist we need to install module , by using below power shell command.

Install-Module -Name SQLServer


Get-Module SqlServer -ListAvailable


 



No comments:

Post a Comment