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 : 639 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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?

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

2	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

1	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

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

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

0	The article was helpful - nice bro. Crniranjanraj, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts