January 11, 2005 at 2:43 am
Hi guys,
I have googled and found many links teaching you how to use Indexing Service and SQL Server together.
My question is why I need to use two together?? Why don't I just use Indexing Service only? What benefit does SQL Server give me?
Thanks.
Michael
January 11, 2005 at 6:17 am
Are you sure you are looking at the right thing? Can you post a few links so I can see what you are reading?
Have you checked out this link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefindservprovspec.asp
January 11, 2005 at 7:26 am
Indexing Service, under NT 4.0, was bundled with IIS. Now, however, it can be installed separately as of Windows 2000 (as a matter of fact, it's what used to index your drives). That's not the same as Microsoft Search, which is what is bundled with SQL Server.
K. Brian Kelley
@kbriankelley
January 12, 2005 at 7:38 am
Q. What benefit does SQL Server give me?
A. SQL Server provides you all the benefits of a Relational Database Management System (RDBMS) that the Indexing Services (cisvc.exe) does not, such as transaction control, security, etc. While the Indexing Service can be used on Windows 2000 Server and Windows Server 2003 it provides no additional features other than to Full Text Index files on the local hard drive of the server.
Additionally, you can use the Full Text Search (FTS) components that ship with SQL Server 7.0 and SQL Server 2000 (installed by default) to truly get the best of both world when storing your files in a SQL Server 2000 table's column defined with the IMAGE datatype and a "file extension" column. See SQL Server 2000 BOL title "Filtering Supported File Types" for more information. While arguments can be made for both sides, i.e., storing the files on disk vs. storing the files in SQL Server, the best approach is to understand your environment and choose the best approach based upon your needs.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
John T. Kane
January 16, 2005 at 11:40 pm
Clear explanation. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply