I have posted the below query before for SQL Server 2005, 2008 and 2008 R2 on https://www.sharepointfire.com/?p=138 and it is still usable for SQL Server 2012 SELECT SERVERPROPERTY('Edition') AS 'Edition', SERVERPROPERTY('ProductVersion') AS 'ProductVersion',...
Blog
Day: October 2, 2013Using ForeFront Identity Manager client for SharePoint
SharePoint 2010 and 2013 both use some parts of ForeFront Identity Manager (FIM) for the synchronization of users between for example AD and SharePoint. It is possible to use the FIM client to monitor this process and review issues related to the User Profile Service...