SharePoint Lover

It's a well-known annoyance when you get a message on SharePoint 2010 about a Correlation

ID for an unexpected error as below.

There are various methods of checking Correlation ID's, but I prefer checking on the SQL Server Log Files instead of

checking on the Log files on the SharePoint front end – that way, you can actually see the details of the error

(assuming you have access to the SQL Server.

1. Note the Correlation ID in the error message (you can now copy and paste these)
2. Log on to SQL Server using a Farm account (or one that does have permissions to the SQL Server) and locate the

   WSS_Logging Database (or whatsoever database that is now used for Logging perchance it has been renamed)

3. Right click on the database and click on "New Query"

    

   

    

4. Enter the following SQL scripts (using my example, replace the name of the database and Correlation ID)

    

   select [RowCreatedTime], [ProcessName], [Area], [Category],

   EventID, [Message] from [WSS_Logging] .[dbo].[ULSTraceLog]

   where CorrelationId='c7832894-4b2d-4bc3-9517-430501c581ec'

    

    

…And then click on Execute

1. More details of the error can then be viewed in detail in the results list