Event ID 7888 – Cannot insert duplicate key row in object ‘dbo.UserMemberships’ with unique index

Error 1: Event Type: Error Event Source: Office SharePoint Server Event Category: Office Server General Event ID: 7888 Date: 4/25/2011 Time: 1:22:02 PM User: N/A Computer: SERVERNAME Description: A runtime exception was detected. Details follow. Message: Cannot insert duplicate key row in object ‘dbo.UserMemberships’ with unique index ‘CX_UserMemberships_RecordId_MemberGroupId_SID’. The statement has been terminated. Techinal Details:…

Read More

List All SharePoint 2010 Databases

If you’re like me you’ve setup numerous SharePoint 2010 test boxes in order to get comfortable with all the great new features. Because I’m running in a test environment I hadn’t been paying too much attention to the SQL server I was using. Yesterday I logged in and found a staggering number of similarly named…

Read More

SQL Aliases and SP_TRACE_CREATE errors on SharePoint 2010

When you use SQL Aliases (something that most people believe to be a good practice as it’s a locally controlled link to the database, and unlike DNS it updates instantly, and Microsoft recommend it here http://technet.microsoft.com/en-us/library/cc298801.aspx#Section6_3) and you have installed SPDiag from the SharePoint Administrator Toolkit, you also need to ensure the Alias name resolves…

Read More

Provide SharePoint Single Sign-On with Active Directory Federation Services

Organizations around the world have been adopting SharePoint rapidly as their collaboration platform of choice. In fact, SharePoint usually becomes so popular that organizations quickly want to expand its use beyond the corporate firewall. Typical extranet SharePoint deployments involve deploying SharePoint in an Active Directory (AD) forest on a perimeter network, or DMZ (see Figure…

Read More

SharePoint Duplicate People Search Results (or none at all)

I ran into an interesting issue with the People Search functionality of SharePoint today (which is the opposite of a problem I ran into sometime back, and which is also covered here) The problem today: People results are duplicated. The problem earlier: No people results at all. The root cause of the issue is the same……

Read More

50 Inspiring SharePoint Based University Sites

Microsoft SharePoint is the fastest growing product in the history of Microsoft! SharePoint’s features includes managing and provisioning of intranet portals, extranets and websites, document management and file management, collaboration spaces, social networking tools, enterprise search, business intelligence tooling, process integration and third-party developed solutions. SharePoint gives you the best of both worlds: out-of-the-box applications…

Read More

Maximum Capacity Specifications for SQL Server

The following table specifies the maximum sizes and numbers of various objects defined in SQL Server databases or referenced in Transact-SQL statements. SQL Server Database Engine object Maximum sizes/numbers SQL Server (32-bit) Maximum sizes/numbers SQL Server (64-bit) Batch size1 65,536 * Network Packet Size 65,536 * Network Packet Size Bytes per short string column 8,000…

Read More

How to Setup Mirroring in SQL Server ?

What is Mirroring in SQL Server ? Database mirroring is an alternative high-availability solution to failover clustering in SQL Server. Database mirroring supports automatic failover, but does not require cluster-capable hardware, and can therefore provide a cost-effective alternative to failover clustering. In this Article, we will implement Mirroring with witness Server and will Automatic Failover too. What…

Read More

Increase download speed in WSUS 3.0

My WSUS 3.0 server constantly got transfer rates between 10 and 30 kB/s. I searched for a solution to control the download speed, but I couldn’t find any way to configure the WSUS download behaviour. Finally I found out that I only needed to set BITS in foreground mode. In WSUS 2.0 this could be…

Read More