Storing and retrieving video into sql 2005

The best advice I can give is "Don't do it".
 
Video takes a lot of space, and SQL2005 is limited to a maximum database size of 1TB - that is not a lot of videos!
 
Instead, store videos on a HDD, and store the path to the video in the DB.
 
Even with later version of SQL server (which can hold much bigger databases) I would strongly recommend that this is a poor idea as insert and select operations will use serious amounts of bandwidth!