Just installed the PDF ifilter in SQL 2005 and created Full Text indexes for several comumns on a table. One of the columns contains pdf documents and is data type image. the others are nvarchar . Sull text searches return correctly on the nvarchar fields but the field containing the PDF document returns empty.
I ran the exe install from ADobe and manually registered the PDF filter. any suggestions would be greatly appreciated.
After looking at all of the variables several times, and following the advice here , at Microsoft and a few other locations and trying it on two different servers without results, I changed the data type
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.