August 2014 – The Blog of Travis Gneiting

SharePoint Error Location with Correlation across Farm

SharePoint Power Shell Command to extract error message from correlation ID across farm.

Merge-SPLogFile -Path “C:\Temp\error.log” -Correlation “ea4db39c-b73a-601a-c58f-6e5284175b86”

http://Flaticon.com
http://www.morguefile.com

SELECT * FROM sys.dm_fts_index_keywords(db_id(‘databasename’), object_id(‘tablename’))

SELECT * FROM sys.dm_fts_index_keywords_by_document(db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))

SELECT * FROM sys.dm_fts_index_keywords_by_property(db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))

SELECT * FROM sys.dm_fts_parser((db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))