Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Attache DOC file to my SQL database

Author  Topic 

belkin_99
Starting Member

27 Posts

Posted - 2008-11-22 : 22:52:44
I have problem about attach a file.doc to my SQL DB, NOT IMPORT FILE, and enable it to be searchable within my SQL database.
Any help will be appreciated.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-11-23 : 16:27:00
I have never heard about attaching a DOC-File to SQL Server.
Are you joking?

Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-23 : 17:09:12
You can with the new FILESTREAM option in SQL Server 2008.
The file is stored on the OS filesystem and is accessible within a column for a table in SQL Server.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

belkin_99
Starting Member

27 Posts

Posted - 2008-11-23 : 18:56:07
I have a SQL database, and the developer enable to attach file dot doc to it.
In addtion, these files are searchable. I tried to configure how they build the query and search the text within these file but i was unable.
Go to Top of Page
   

- Advertisement -