Posted by manmit.walia on 06/29/06 20:48

Hello All,
I am stuck on a task that I need to complete. What I have is a SQL 2005
DB running with a Table called Docs. The table structure consists of
the following:

Table Structure for Docs
------------------------------------
DocID int - Primary Key
ClientID int - CustomerID
CreatedByUser nvarchar - UserName
CreatedDate datetime - Date of Document stored in SQL DB
Content image - Bytes of actually document
ContentType nvarchar - (application/msword)
ContentTypeImage nvarchar - Path to Image of Document Type(such as
word.gif")
ContentSize int - Size of Document
FriendlyName nvarchar - Name of Document

What I want to do is create a query to export all documents from the
SQL DB to a local folder on the server or even my local pc. Can this be
done?

Thanks

[Back to original message]