Although SQL Server can store, index and search (to a certain degree) complex (non atomic) data types, it offers no native support for them.

BLOB's like audio, video are huge, non-atomic data types that consists of parts and subparts and that's non so easy to represent int a relational db.

BLOB's are mostly stored outside the DB and referenced through pointers. The manipulation itself is afaik done via traditional file IO operation.

I think this would be a move into object-relational (object-oriented) direction.

Maybe in the next release...because I think there is definitely a demand.

Frank

http://www.insidesql.de