Friday, August 27, 2010

SPS 2010 Developer Dashboard...helps in troubleshooting

Stsadm –o setproperty –pn developer-dashboard –pv ondemand (or “on” or “off”)

This will put a small icon in the top right of your sharepoint page. Click it and it will display debugging info on your page all the way at the bottom. The cool thing is its activated by each person, by that if you click it, only you see the information.

Very useful!

Language Translator for SharePoint

This thing is cool. Just add a content editor webpart. Paste the code in a .txt file and link the content editor to the .txt file in the sharepoint library.

really cool and a load of time savings!

Thursday, August 26, 2010

Moving site collections to new databases SharePoint 2010

On the SharePoint Server, open command prompt to hive.
Type Stsadm -o enumsites -url > .xml

I used this for example:
Stsadm -o enumsites -url http://sp-giga > c:\sites.xml

Edit the sites.xml file to remove all sites that you do NOT want to move to another content db.

Then once you have done that, save the file back to c:\sites.xml.
Type Stsadm -o mergecontentdbs -url -sourcedatabasename -destinationdatabasename -operation 3 -filename

For example:
Stsadm -o mergecontentdbs -url http://sp-giga -sourcedatabasename wss_content -destinationdatabasename wss_content_sc_IT -operation 3 -filename c:\sites.xml

Check to make sure the sites moved over in central admin, manage content databases

Tuesday, August 24, 2010

SharePoint 2010 fly-out menu NOPE not there!

Flyout levels are still a problem for SharePoint, you will need to modify the v4.master page and change the string value DynamicDisplayLevels from “1” to “3”, and this will allow sub menus to fly out three levels. In order to do this, make sure you have the publishing feature on and the navigation is set to show sub-sites. In order to change this value, use SharePoint designer, open up the master page and click code view. Do a find for the string. Save it, publish it, approve it.

SharePoint 2010 .pdf's here we go again

This post covers everything to a tee, and works perfectly. The only thing I have to add is this:

In the web browser, open Central Admin, under Application Management, click manage service applications.

Left side, click file types. Click new file type, put .pdf in there. Scroll down the list you should see the pdf icon there now and associated to adobe.

This actually worked better in 2010 then 2007!

SharePoint 2010 pre-req's location for download

Here is the location of all those pesky pre-reqs you need prior to installing sharepoint. You ask why do this? Well, if you have a lab setup with NO internet connectivity it is a very useful thing to have them all on a usb stick!

Friday, August 20, 2010

SQL server at (Blank) has an unsupported version 10.0.2531.0

You update SQL 2008 to SP1 thinking ok I am ready......NO U R NOT! You will get the folowing error:

SQL server at [Your-DATABASE-SERVER] has an unsupported version 10.0.2531.0. Please refer to “” for information on the minimum required SQL Server versions and how to download them.

You might see threads here an there say that the minimum build number for SQL server is 10.0.2531.0. This is not very accurate as the minimum build for SPS 2010 for the SQL 2008 Enterprise Edition is the version number 10.0.2714.0 which is the cumulative update package 2. They are up to five now which I will post the link here:

If I had read the Pre-req from Microsoft for SharePoint 2010 it does state this.......But who reads! :)

SharePoint 2010 n SQL 2008 can't connect to DB

  1. Open the SQL Server Configuration Manager (Start > SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager
  2. Navigate to the SQL Server Network Configuration > Protocols for MSSQLSERVER node in the tree view
  3. Enable TCP/IP and Named Pipes (you’ll be warned that these changes will not apply until you the service is shut down)

That will allow you when installing SPS 2010 to connect to a SQL 2008 Server. This took 4 hours to finally figure out.