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

Posted by Crniranjanraj under Sql Server on 10/3/2015 | Points: 10 | Views : 476 | Status : [Member] | Replies : 3
This is just for experimental sake as one of my friend asked me if we can open a video file from Sql Server.Curious to know if it is possible?




Responses

Posted by: Rajnilari2015 on: 10/5/2015 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
2
Down

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

Posted by: Rajnilari2015 on: 10/5/2015 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
1
Down
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

Posted by: Crniranjanraj on: 10/5/2015 [Member] Starter | Points: 25

Up
0
Down
The article was helpful - nice bro.

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

Login to post response