Profile of Michael Coleman
WebDevStudios.com Staff
SQL: Script to attach and detach Databases for mass moves
I dont know about most of you, but this is something that I have had to do on multiple occasions, moving databases to a new SAN/drive/etc. And the environments that I normally have to support have WAY too many databases to sit and detach, move, then reattach by hand. A lot of scripts out there [...]
MOSS: Enable versioning from C#
Add a web reference to the Lists.asmx web service. Call it whatever you want, I used “PDLists”. The following code will access a document library or list, and enable versioning. Simple, but effective.
I use this code in a command line application, saves a lot of time from not logging into a site, finding the list [...]
MOSS: Excessive Sync errors on Sharepoint 2007 Front End Web Server
In several MOSS deployments with multiple front ends, I have noticed many sync issues in the event logs.
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:
System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object ‘dbo.UserMemberships’ with unique index ‘CX_UserMemberships_RecordId_MemberGroupId_SID’.
The statement has [...]
OCS: Microsoft Communicator Mobile
After installing and setting up your Communicator mobile, you have probably recieved an error about version compatibility, thanks Microsoft!
The issue is related to the Client Filter.
1. You need to open up your Pool on your internal OCS.
2. Open the client version filter properties.
3. Change the CPE value to 2.0.387.* >= Allow
4. Restart all services.
5. On [...]
MOSS: Shared Service Provider Search Service Error
I recently lost a search and index server (virtual server) due to a virtual host server eating dirt.
I had some issues with getting the services transfered, since I also made the mistake of only have central administration running on the same box that was lost.
After moving the services, and hoping it worked to no avail, [...]
MOSS: Installing Adobe PDF Ifilter 6.0 on MOSS 2007 (Now With WSS Support)
Here are the instructions for installing the PDF IFilter 6.0 on a SharePoint 2007 server to allow PDF files to be indexed (full text) by the Search and for the icon to be shown next to PDF documents.
Download Adobe PDF IFilter 6.0 from Adobe.
Stop the IIS Admin service: Start -> Run -> services.msc -> IIS Admin Service [...]
