How can I open a video file using Sql Server 2012? [Resolved]

I have written an article on the same . please find that here http://www.dotnetfunda.com/articles/show/3154/invoke-a-video-file-from-sql-server-using-powershell

--
Thanks & Regards,
RNA Team

Crniranjanraj, if this helps please login to Mark As Answer. | Alert Moderator

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

The article was helpful - nice bro.

Crniranjanraj, if this helps please login to Mark As Answer. | Alert Moderator