content managment in sql 2005

hi

before years it says that store files on the hard drive and stor only links
in databse is that role true till now or new versions of sql work good even
if files stored in the database ?

and haw the client computer knows what type of data it is retriving like
..doc or .pdf or .avi , if its saved as binary or any other blob formats ?

thank you

--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643

SQL 2008 has improved on this and it's really neat how they make it all
work.

"Pure Heart" wrote in message
news:9A997B09-A83A-4D78-9EA9-A9F2B33BCE76-at-microsoft.com...
> hi
>
> before years it says that store files on the hard drive and stor only
> links
> in databse is that role true till now or new versions of sql work good
> even
> if files stored in the database ?
>
> and haw the client computer knows what type of data it is retriving like
> .doc or .pdf or .avi , if its saved as binary or any other blob formats ?
>
> thank you
>
> --
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643