Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details."...

You have seen the list of SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated and now there are few additional KBAs that pertains to SQL Server Standard Edition has been updated recently with new and major modifications . ( You may find majority of KBA numbers...

There hasn't been much changes to the KBAs and here is complete list of items/pages that were were recently modified: Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Edition FIX: You receive an incorrect result when you run a full-text query against a table that uses the Chinese...

Here is the useful script that I have workd out (part of it obtained from Technet) in order to find the name of unique index that refers full text index SELECT OBJECT_NAME ( fti . object_id ) AS 'Table Name' , i . name AS 'Index Name' , c . name AS 'Column Name' FROM sys . fulltext_indexes...