1. First, reach the content databases management page from Central Admin site.

Select the database you want to move – rest of the demo shows moving WSS_Content_2 across two SQL Server instances.

2. Check the remove content database option. This just removes the content database from SharePoint activity, contents are safe in the source SQL server. Click OK.

3. Using SQL management studio, detach the database from the source SQL Server instance. In this case, source server is a named instance (simonsk-sql\second) in the same SQL server machine. In your deployment this can be the default instance on another SQL server machine.

4. Move the mdf and ldf files from the source server location to the targe server location.

5. Connect SQL Server management studio to the target server instance. In this case, the target server instance is the default SQL instance in the same machine.

6. Select the copied database files and attach to the target server

7. Go to Central admin page for managing content database and click add new content database. Type the name of the SQL Server (with instance if applicable), type the name of the database (in this case WSS_Content_2) and click OK.

With these 7 steps, the content database is transitioned from the source SQL server to the target SQL server. Note that the ChangeLog (that tracks all changes to the SharePoint content for a given window of time) is cleared as part of migrating a database between two SQL Server instances. This implies Search will need to reindex this content since the history associated with last Search watermark is cleared as part of this operation.

More From pstilgoe

• Sharepoint – Creating Content Databases
• Best Practices Resource Center for SharePoint Server 2007
• Microsoft Office SharePoint Server (MOSS) 2007 Limits

Ask pstilgoe To Recommend Your Posts

Add the survey list to the web part pages as the ListView web part

Site Actions –> Edit Page –> Add a Web Part

Under Lists and Libraries, choose the survey list and add to the web part page

Now you get the ListView web part for the survey.

On the web part settings Edit –> Modify Shared Web Part

Under the Selected View —> Change the View to “Summary View”

Then provide the contributor-level permissions to the users, who want to participate in the survey

Now it won’t show the option for Graphical Responses for everyone it will just show the total number of responses.

If you want to get back old-view, just flip the view back to “Overview”

However the user could still click the title of the Survey & get access to the survey results that way, so to prevent this you need to edit your survey webpart & make the following changes to the settings –

View – Summary View (this should already be done from the steps above)

Toolbar Type – Summary Toolbar

Chrome Type – None

Now your users can vote & see the total number of votes overall but cannot see the number of responses for each answer.

More From pstilgoe

• How to embed a powerpoint presentation into a Sharepoint page
• How to Prevent users from changing views in Sharepoint
• How to easily move / copy list items from one sharepoint list to another

Ask pstilgoe To Recommend Your Posts

If you get this error you probably havn’t assigned an indexer when creating the content Database

Go into :

SharePoint 3.0 Central Administration -> Application Management -> SharePoint Web Application Management -> Content databases -> Content Database used for the site > Set the Search Server

More From pstilgoe

• Error: There is no file with URL ‘http://test-url’ in this Web.
• This page cannot be edited in SharePoint Designer
• Creating Site Collection – The template you have chosen is invalid or cannot be found

Ask pstilgoe To Recommend Your Posts

If you want to hide certain menu items from the “Welcome” menu in a SharePoint site.

You can do the following:

1. Go to the following folder at the MOSS / WSS server:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\CONTROLTEMPLATES

2. Open file Welcome.ascx in the editor

3. Search for elements. For the ones you don’t want to display users, add the following attribute:
Visible=”False”

For example:

Text="<%$Resources:wss,personalactions_personalinformation%>”
Description=”<%$Resources:wss,personalactions_personalinformationdescription%>”
MenuGroupId=”100″
Sequence=”100″
ImageUrl=”/_layouts/images/menuprofile.gif”
UseShortId=”true”
Visible=”False”
/>

This will hide “MySettings” menu.

Be aware as you are modifying a sitewide template the changes you make will be reflected throughout the Sharepoint site.

More From pstilgoe

• How to add Blackberry support for MOSS 2007 & Infopath Forms
• How to Prevent users from changing views in Sharepoint
• How to delete the Shared Service Provider in MOSS 2007

Ask pstilgoe To Recommend Your Posts

Go to the google gadgets site & find which one you want to use.

Then click the ‘add to your webpage’ button.

Make any customisations and click the “Get the code” button, then copy the code to your clipboard.

Now go to your SharePoint site and add new content editor web part to the page you want the gadget on.

Click the web part menu of the content editor web part and go to Modify shared web part.

In the tool pane click the source editor button and then paste the contents of your clipboard in the window that appears.

Click Save on the pop and then OK on the tool pane, all done, your Google Gadget should now be working in your Sharepoint site.

More From pstilgoe

• How to add Blackberry support for MOSS 2007 & Infopath Forms
• How to Prevent users from changing views in Sharepoint
• How to easily move / copy list items from one sharepoint list to another

Ask pstilgoe To Recommend Your Posts

Speculators are the latest breed of dotcom entrepreneur, buying up website domain names – and making their fortune by dealing in them.

Neil Stanley goes to bed each night knowing he will wake up a little richer. All over the world, the clicks of computer mice are depositing a few more pounds into his account. His secret is that he was smart enough to ask: what’s in a name?

Stanley is a trader in domain names, the addresses of websites which commonly follow ‘www’ and end with ‘.com’ or ‘.co.uk’. Once a banker at Goldman Sachs, he now has a different portfolio of lucrative investments including bridalfashion.co.uk, onlinecareers.co.uk, schoolguide.co.uk, sendingflowers.co.uk and impotency.co.uk.

He is one of a growing band of cyber-speculators able to make a living from buying and selling domain names at a substantial profit. No effort or expertise in building websites is required. Instead, a PC with broadband connectivity and an eye for a popular generic domain is enough to draw traffic and unlock a fortune. Recently Stanley was involved in a deal which registered a domain name for almost nothing and sold it for $40,000 a few weeks later.

‘It’s amazing how many people go to the address bar and type in a generic name instead of going to Google,’ said the 44-year-old from Bath. ‘If you’ve got mortgages.co.uk, you’ve got a licence to print money. It’s an industry in its infancy and there’s a bit of a gold rush on at the moment. It’s amazing that the UK hasn’t really woken up to it yet.

‘The analogy is real estate. The internet got invented and all the land is being bought up. In 10 years’ time any word you can think of will be taken: all the real estate will be gone. If one day someone wants to build a skyscraper on it, you’ve made a fortune.’

There are about 140 million domain names worldwide. The 6.6 million with the ‘co.uk’ suffix, a total swelling by 140,000 per month, are registered with an organisation called Nominet. But most trading is done in a secondary market via specialist websites, such as whois.sc, which can show whether a name has already been taken, suggest close alternatives or offer a route to the existing owner in case they are willing to sell.

Stanley acquired kids.co.uk and is planning to make it a non-profit site for children, but leaves the majority of his domain names sitting idle, or ‘parked’. This means that they are hosted by a specialist website as a simple, customised template containing relevant adverts. Every time someone visits the page and clicks on one of the adverts, the name owner and the website share revenue.

‘Whenever I register or buy a domain name, the first thing I do is park it,’ said Stanley, who is writing a book on the subject. ‘Anyone who then types in that name will see the web page and, if they click on an ad, it generates money. I registered noworryloans.co.uk last autumn and it probably earns £10 a week on its own. My whole portfolio is bringing in hundreds of pounds every week without me touching it, and some people are creaming in thousands. My conviction is that this going to become mainstream because it’s so easy.’

Sedo, or ‘Search Engine for Domain Offers’, claims to have the world’s biggest database of names for sale, with more than 10.5 million listings. Its total sales in 2007 amounted to £37m. In Britain it has overseen the sale of sport.co.uk for £135,000 and mobile.co.uk for £120,000. Sedo also ‘parks’ more than 3 million domains and paid out £25m to customers last year.

Nora Nanayakkara, business development director of the company, said: ‘We’ve spoken to people who are now doing this as a full-time career. People are putting their kids through school on the money they make.’

Last month, cruises.co.uk set a British record when it fetched £560,000. But, America is one step ahead. Kevin Ham, dubbed ‘the most powerful dotcom mogul you’ve never heard of’, is estimated to have stockpiled 300,000 domains that generate $70m a year. He even struck a deal with the government of Cameroon so that when users mistakenly type ‘.cm’ instead of ‘.com’, he gets a slice of the cake.

The 10 most valuable domain names auctioned by Sedo
1 Vodka.com, $3m

2 Chinese.com, $1.1m

3 Website.com, $750,000

4 Telecom.com, $700,000

5 Annuity.com, $600,000

6 Gays.com, $500,000

7 Gibraltar.com, $360,000

8 Sport.co.uk, $265,000

9 Mobile.co.uk, $247,000

10 Fly.co.uk, $180,000

More From pstilgoe

• Creating filtered views in Sharepoint
• Lapsed domain names bought in seconds
• Internet domain names return hefty profits

Ask pstilgoe To Recommend Your Posts

The Sharepoint content editor gives you a double space everytime you press enter, if you just want a single space press Shift+Enter

More From pstilgoe

• Enable anonymous access on a Sharepoint site
• Enhanced Content Query Web Part
• Sharepoint Blog Template – No content types

Ask pstilgoe To Recommend Your Posts

Open the page you want the left hand navigation to appear on in a text editor or Sharepoint Designer & remove the following lines:

asp:Content ContentPlaceHolderId=”PlaceHolderLeftNavBar” runat=”server”>

asp:Content ContentPlaceHolderId=”PlaceHolderNavSpacer” runat=”server”>

Save the page & now you have the left hand navigation bar !

If you want to change this on all future webpart pages you will need to make the changes to the Web Part template files which are located here on your server:

\\YourServer\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\1033\STS\DOCTEMP\SMARTPGS

The go through each template & delete the following lines:

asp:Content ContentPlaceHolderId=”PlaceHolderPageImage” runat=”server”>
asp:Content ContentPlaceHolderId=”PlaceHolderLeftNavBar” runat=”server”>
asp:Content ContentPlaceHolderId=”PlaceHolderNavSpacer” runat=”server”>

Now all future webpage parts created will have the quick launch bar on the left hand side.

More From pstilgoe

• How to add Blackberry support for MOSS 2007 & Infopath Forms
• How to embed a powerpoint presentation into a Sharepoint page
• How to Prevent users from changing views in Sharepoint

Ask pstilgoe To Recommend Your Posts

How to submit an InfoPath form to a Windows SharePoint Services document library

Article ID : 826993
Last Review : November 17, 2004
Revision : 2.0

Design your form data source and layout
Submit the form data to a SharePoint Services document library
Use script to submit the form data to a SharePoint Services document library in InfoPath 2003
Use the UI to submit the form data to a SharePoint Services document library in InfoPath 2003 Service Pack 1
Test your form

INTRODUCTION
In Microsoft Office InfoPath 2003, you cannot submit form data to a Microsoft Windows SharePoint Services document library directly. This article describes how to design a form template that uses script to submit form data to a Windows SharePoint Services document library.

In InfoPath 2003 Service Pack 1, you can submit the form data to a Windows SharePoint Services document library directly by using the UI. This article contains the steps that you have to use to do this.

MORE INFORMATION
Design your form data source and layout
1. Start InfoPath 2003. Design a new blank form.
2. In the Data Source task pane, add a data source to your form. To do this, follow these steps:a. Right-click myFields, and then click Add.

The Add Field or Group dialog box appears.
b. Type FirstName as the name of the field, and then click OK.
c. Repeat step a. Type MiddleInitial as the name of the field, and then click OK.
d. Repeat step a. Type LastName as the name of the field, and then click OK.

3. Add myFields to your form.
4. Click Section with Controls.

Submit the form data to a SharePoint Services document library
You can use script or the UI to submit the form data to the SharePoint Services document library.

Use script to submit the form data to a SharePoint Services document library in InfoPath 2003
1. On the Tools menu, click Submitting Forms.

The Submitting Forms dialog box appears.
2. In the Submitting Forms dialog box, click Enable Submit.
3. In the Submit box, click Submit Using Custom Script.
4. Click Open Microsoft Script Editor, and then click OK.

Microsoft Script Editor starts.
5. Modify the OnSubmitRequest event as follows.

Note You must change the value of the strURL variable to a valid URL in the code. The URL in the following code sample references a server that is named ServerName, a SharePoint site that is named SiteName, and a document library that is named DocumentLibraryName.function XDocument::OnSubmitRequest(eventObj)
{
// If the submit operation is successful, set
// eventObj.ReturnStatus = true.
var fSuccessful = false;

// Set the URL of the file that you want to submit here.
var strUrl = “http://ServerName/SiteName/DocumentLibraryName/testform.xml”;

try
{
// Create an xmlhttp object.
var oXmlHttp = new ActiveXObject(“MSXML2.XMLHTTP”);

// See whether the document with the same name already exists in the Windows SharePoint Services (WSS) document library.
oXmlHttp.Open(“HEAD”, strUrl, false);
oXmlHttp.Send();

// No document with the URL has been found. Continue to submit.
// If you must replace the original file, you must call
// oXmlHttp.Open(“DELETE”, strUrl, false) to delete the document
// in the WSS document library.
if (oXmlHttp.Status == 404)
{
// Put the document in the WSS document library.
oXmlHttp.Open(“PUT”, strUrl, false);
oXmlHttp.Send(XDocument.DOM.xml);

// A 200 status code or a 201 status code indicates that the form has been submitted successfully.
if (oXmlHttp.Status == 200 || oXmlHttp.Status == 201)
{
fSuccessful = true;
}
}
}
catch (ex){}

if (fSuccessful)
{
XDocument.UI.Alert(“Document submitted successfully.”);
eventObj.ReturnStatus = true;
}
else
{
eventObj.ReturnStatus = false;
}
}

6. Save the script. Close Script Editor.
7. Save your form template as SubmitToWSS.xsn.

Use the UI to submit the form data to a SharePoint Services document library in InfoPath 2003 Service Pack 1
1. On the Tools menu, click Submitting Forms.

The Submitting Forms dialog box appears.
2. In the Submitting Forms dialog box, click Enable Submit commands and buttons.
3. In the Submit to section, click SharePoint form library.
4. In the Submitting Forms dialog box, click Add.

The Data Connection Wizard starts.
5. Input your SharePoint Services form library link in the SharePoint form library box.

Your library link may look similar to the following:

http://ServerName/SiteName/DocumentLibraryName

6. Type the document name in the File name box.

You can use a document name such as TestForm.

Click Next.
7. In the Data Connection Wizard, click Finish.
8. In the Submitting Forms dialog box, Click OK.
9. Save your form template as “SubmitToWSS.xsn.”

Test your form
1. On the File menu, click Fill Out a Form.
2. In the Fill Out a Form task pane, click SubmitToWSS.
3. Complete the form.
4. On the File menu, click Submit.

If the form is submitted successfully, you receive a message that indicates this.
5. Quit InfoPath. If you are prompted to save your changes to the form, click No.
6. Start Microsoft Internet Explorer. Locate your document form library.

For example, your document form library may be http://ServerName/SiteName/DocumentLibraryName.

A new item that is named testform is in the document library.
7. Click testform.

The form that you submitted opens in InfoPath 2003.

If you want to uninstall the templates you’ll have to use stsadm like this:

stsadm -o deletetemplate -title