Move Sharepoint Content Database from SQl server 2005 to SQl server 2008 R2

Attach and Detach SQL server database 2005 to 2008 R2

It is going on

Opening WebPart Maintenance Page

Shortcut to open Instead of going to the Edit Properties form of the page, we can easily open the WebPart Maitenance page by just adding the following query string to the page URL
?contents=1
 So, if your page URL is 'http://kar/pages/default.aspx' then after appending the query string it should look like ' http://rams/pages/default.aspx?contents=1'

Using this approach, we can open the webpart maintenance page for all the forms pages (like /pages/forms/allitems.aspx?contents=1).

But its not safe to remove or add any webparts in these pages, as they may effect the normal funcitonality.

This approach works on both MOSS 2007 and SPS 2010.

Copy from One database table data to anoother database table data MS SQL Query

insert into StarDB.dbo.Associate1 select * from StarDB_Production.dbo.Associate1

ASP.Net Tab Container Control

How to find the Infopath user's available in that group via Dataconnection

It is Process

Query for SQL 2008

It is Process