Re: code Sample

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Kane (jt-kane_at_comcast.net)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 08:37:38 -0800

John,
The MAJOR thing wrong with the below link is that it makes NO reference to
the advantages of storing documents (MS Word, Excel, Adobe's PDF, etc.) and
only references the storing of images, such as *.jpg files (which can also
be FT Indexed with existing JPEG IFilters). While, I don't want to start a
flame war, and I've not reviewed all of the KB articles (I will at a later
time, as I have to go to work ;-), I strongly disagree with the premise of
this links recommendation as it makes NO reference to advantage of storing
files for the purpose of accessing the content of these files via Full text
Search that is fully support by Microsoft in SQL Server 7.0, SQL Server 2000
and vastly improved in SQL Server 2005.

Respectively,
John 

-- 
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <JohnBell@discussions.microsoft.com> wrote in message
news:EFED2C44-641B-4AD8-87D2-4DFB9E45214C@microsoft.com...
> Hi
>
> The following article and links to KB articles should give you everything
> you need!
> http://www.aspfaq.com/show.asp?id=2149
>
> John
>
>
> "Sathian T" wrote:
>
> > Hello,
> > Can someone help me with a SQL code sample to insert a Picture /
Documentin
> > image data field?
> >
> > Regards
> >
> > Sathian
> >
> >
> >

Relevant Pages

  • Re: Using BLOBs in SQL
    ... a brief review tells me that not one makes reference to Full-text Search of ... I just blogged how to upload PDF files into a SQL Server 2000 ... >>> We are looking at scanning certain paperwork and storing it with the ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Article Storage: Files vs. Database
    ... With file-based articles, ... approaches are to either store the articles in aspx files, possibly indexed by the database, or to store the article text in the database. ... Some advantages of storing them in the database are ease of some operations, and the option of using SQL Server 2005 text index to implement search. ...
    (microsoft.public.dotnet.framework.aspnet)
  • SQL Server DataType for articles
    ... I am using SQL Server Express Edition with ASP.NET. ... which data type to use for storing large articles. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ADO/MDAC on Terminal Server
    ... XP database system to SQL Server 2000. ... front end is running on the Terminal Server. ... MDB file due to fixes and modifications, ... "missing reference" error as the MDB file opens up. ...
    (microsoft.public.data.ado)
  • Re: Desktop SQL Server
    ... It's also hard to provide you with a better reference because you didn't ... uninstalled when the SQL server is installed. ... Server but, according to my reading on this, the Microsoft Jet Engine ... who runs an application that uses the SQL Server will have to uninstall ...
    (microsoft.public.access.externaldata)