Hmmm...

Office SharePoint Server

N/A

N/A

With SP1, any usage data that is older than 365 days is now deleted.  Previously, usage data was deleted after 366 days. This caused performance issues.

I found this in an article about what was fixed in SP1 for MOSS. Wonder what this one day have of importance..

Great posts about FBA authenticated sites

http://devcow.com/blogs/jdattis/archive/2007/03/01/Office-SharePoint-Server-2007-Forms-Based-Authentication-FBA-w-MySites-Walkthrough-Part-2.aspx

http://devcow.com/blogs/jdattis/archive/2007/02/23/Office-SharePoint-Server-2007-Forms-Based-Authentication-FBA-Walkthrough-Part-1.aspx

And how to use My Site and personal features for ASPNET membership users. It's a must use guide for how to enable "my links" for e.g. membership users.

Great posts about FBA authenticated sites

http://devcow.com/blogs/jdattis/archive/2007/02/23...

http://devcow.com/blogs/jdattis/archive/2007/03/01...

And how to use My Site and personal features for ASPNET membership users. It's a must use guide for how to enable "my links" for e.g. membership users.

Customizing "My sites"

Seems like a valuable blog post:

http://blogs.msdn.com/sharepoint/archive/2007/03/22/customizing-moss-2007-my-sites-within-the-enterprise.aspx

Developers wanted for positions in Warsaw, Poland

If you my dear reader are situated close to Warsaw, Poland and have the desire to work with leading edge SharePoint technologies, don't hestiate - write me an email or write to "mailto:ncs@netcompany.com?subject=I kick ass - hire me!" and join our team.

We're developing a state of the art case/document management system on top of MOSS2007 and have extended MOSS with all the stuff that MS didn't do... This is an execellent opportunity for you to develop your ASPNET2.0-3.0 skills and a chance to deep dive into MOSS-land.

Applications wanted! http://www.netcompany.com/english_career_solutions...

Problems by adding existing content database

Today I had a huge problem related to moving databases. On a test server the disk was out of space and by a short analysis the horrifying reason revealed itself: the default data store of the SQL server was on the C-drive (and not the intended D-drive for data). Hence - all content databases created ended up on the C-drive.

So the quest began to move the content databases to the right partion and reconnect them to SharePoint. The procedure was:

1. Remove the content database via the central administration site
2. Detach the content database using SQL Management Studio
3. Move the files to the D-drive
4. Attached the content database to the database again using SQL Management Studio
5. Add the content database using the central administration site

Simple - but then again, there was huge problems with one of the content databases.

Every time I tried to reconnect it to SharePoint via the central administration site I got this error:

"A SharePoint database named WSS_Content_e566fe03fb8d4a4988905e23aad8d817 already
 exists.  You must supply another name for the new database."

(Name of the content db to reconnect: 'WSS_Content_e566fe03fb8d4a4988905e23aad8d817')

I tried all kinds of tricks on the SQL server, including renaming the database - in the list of content databases the database came back but with zero sites in it, so non-usefull solution.

It seemed like SharePoint kept a reference to this content database in some records since, iisreset, server reboot etc. did not help - it continued to ignore this database.

The solution was *tada*:

1. Open the config database (SharePoint_Config)
2. Open the "dbo.Objects" table
3. Execute this SQL statement:
   Delete From Objects Where Name='WSS_Content_e566fe03fb8d4a4988905e23aad8d817'
4. Run "iisreset"

Then retry to reconnect the existing content database again.

It worked in my case, so no guarantees on this one.

SharePoint Theme Song (?)

For those of us who have done SharePoint since 2001 or just within latest years - I think this song really hits the spot. Start up your development environment, use the API - use the new eventhandlers, workflows and discover all the aspects in the platform ;-)

Take that - Patience..

Patience

Just have a little, patience

I'm still hurting from a love I lost,
I'm feeling your frustration,
But any minute all the pain will stop,
Just hold me close inside your arms tonight,
Don't be too hard on my emotions

(Chorus)
Cause I, need time,
My heart is numb, has no feeling,
So while I'm still healing,
Just try and have a little patience,

I really wanna start over again,
I know you wanna be my salvation,
The one that I can always depend,

I'll try to be strong, believe me,
I'm trying to move on,
It's complicated but understand me,

Cause I, need time,
My heart is numb has no feeling,
So while I'm still healing,
Just try and have a little patience yeah,

Have a little patience, Yeah

Cause this scar runs so deep,
It's been hard,
But I have to believe,

Have a little patience,
Have a little patience,

wooh

Cause I, I just need time,
My heart is numb has no feeling,
So while I'm still healing,
Just try, and have a little patience,

Have a little patience,
My heart is numb has no feeling,
So while I'm still healing
Just try and have a little... Patience

Creating distribution groups with SharePoint

You can enable SharePoint to create distribution groups in your domain.

SharePoint also provides the SharePointEmailWS-webservice (sharepointemailws.asmx) which you can use to create contacts and distributiongroups.

I've only managed to get this webservice to work in context of the central administration site (hence reference it to the http://portal:port/_vti_bin/sharepointemailws.asmx), in case you'll try to use the webservice to create these object types in AD.

Findings:

1. The RequestInfo object which is a parameter for the CreateDistributionGroup method should have the "RequestorEmail" set to string.empty. The RequestID should be a GUID.

2. The ContactCN parameter for the CreateDistributionGroup should also be string.empty

If you don't comply with these findings the DG will be created in the list of distribution groups to approve within the central admin site - but you cannot approve them. Trying so just result in an error.

Also remember to configure the distribution group OU in the central admin site (and grant the app pool user the rights to create and manage objects in the OU) in order to enable the creation of entities in AD and use of the webservice.

Copy.asmx - not what you would expect

Well - depends on your prerequisites ofcourse. I was so naive that I thought I could use this to copy an item from one farm to another. First I thought there was a restriction in the webservice and method so it was designed to work for farms within the same domain, since there is no way to specify remote credentials. But specifying an URL not being part of the farm just throws errors for the "CopyIntoItems" method. So you can use the copy.asmx webservice when you work within the same farm. (I thought that this method was the equivalent of the "send to other location" method in the UI - if that's the case, they do something else in the UI..)

Hotfix for SharePoint available

Recently we had some problems with templates saved as STP files. We do a lot of these and when you setup pages with connected webparts and specific views - the pages based upon the STP templates crash.

Example:

The error is also described in this KB article:

Changes that you make to the "List View" Web Part are not retained after you save the site as a template in Windows SharePoint Services 3.0

http://support.microsoft.com/kb/926284

There is a hotfix for SharePoint available here to solve this and other important issues:

934790  Description of the Windows SharePoint Services 3.0 hotfix package: April 12, 2007

http://support.microsoft.com/default.aspx?scid=kb;EN-US;934790