During the deployment of new project for an application that is accessed worldwide by one of my client. Ther were looking to implement Full Text Search as well due to the nature of application. For your information SQL-FTS: SQL Server Full Text Search which allows fast and efficient querying when you have large amounts of unstructured data. The ...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: ''Internal Query Processor Error ...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: The event information that is generated by a child package does not have a ''User:'' prefix in Integration Services in SQL Server 2005 ...

Yet another information on cumulative update for SQL Server 2005 Service Pack 2 installations and make are note of the following: This cumulative update package will be released in August 2007. The information that is presented here is subject to change without prior notice at any time before cumulative update package 3 is released. Microsoft SQL ...