Store files in the database?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


How do I store files in a database? I have done something similar before in
a none microsoft language in a previous lifetime, byt breaking it down into
chunks and storing it in a BLOB field. Is this the same in SQL?

I have an app written for windows in C# with SQL 2000 on the back. I have a
print engine which users XML documents as the print document template, and
was hoping I could store these in the database, rather than shipping actual
documents out with the app. The idea being I retrieve the docs at runtime
from the db, rebuild them on the client, then print them off.

Any ideas ?

Thanks

Ste
.

Relevant Pages

  • Re: WebDav
    ... > Someone please let me know how to use WebDav to store Files in Sql ... database rather then in File system. ... I'd try the WebDav newsgroup (not sure which one that is off the top of my ...
    (microsoft.public.sqlserver.xml)
  • Fixed
    ... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
    (microsoft.public.sqlserver.server)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)