I just tried this for the first time ever using
PowerShell and it worked. The below are the steps that I followed
A) Write a powershell script file , say
"video.ps1"
B) Put the content as
Start-Process -FilePath "D:\songs\1.mp4"
C) Save the "video.ps1" file
To run PowerShell from SQL Server Management Studio
A) Open SSMS as Administrator Priviledge
B) Open Object Explorer.
C) Navigate to the node for the object to be worked on.
D) Right-click the object and select Start PowerShell.
E) Type
D:\video.ps1
as
PS SQLSERVER:\SQL\SAMDK13050003\DEFAULT+sa\Databases\ExperimentalDB\> D:\video.ps1
in my case.
Your video file will be open
Hope this helps
--
Thanks & Regards,
RNA Team
Crniranjanraj, if this helps please login to Mark As Answer. | Alert Moderator