Add / remove options from an existing SQL database

When there is a need to change settings of an existing Ms SQL database you will need to add ASP.NET SQL Server Registration into windows registry.

It can be done using the following method.

Navigate to [drive:]\%windir%\Microsoft.NET\Framework\version folder on your Web server, and type aspnet_regsql on the command prompt.

E.g.: 

C:\>cd Windows

C:\Windows>cd Microsoft.NET

C:\Windows\Microsoft.NET>cd Framework

C:\Windows\Microsoft.NET\Framework>cd v2.0.50727

C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql

After registering this functionality existing settings of existing databases can be altered after creation.

More information on the tool can be found on the following reference link.

Reference: http://msdn.microsoft.com/en-us/library/ms229862%28v=vs.80%29.aspx

How to get the build version of SharePoint 2010

Keeping track on SharePoint 2010 upgrades are critical for maintenance and development using SharePoint.
There are three methods from which the build version of SharePoint 2010 can be checked.

• From the SharePoint 2010 Central Administration

Go to SharePoint 2010 Central Administration -> Upgrade and Migration -> Check Product and patch Installation Status

• From PowerShell (registry entry)

 Go to SharePoint 2010 Management Shell and enter the following script to get the SharePoint 2010 version registered in the Windows registry

(Get-item "hklm:software\microsoft\shared tools\web server extensions\14.0").Getvalue("version")

• From PowerShell (farm build version)

 Go to SharePoint 2010 Management Shell and enter the following script to get the SharePoint 2010 farm build version

(get-spfarm).buildversion

The newest updates on SharePoint 2010 Server can be checked from the following reference location.

References: http://technet.microsoft.com/en-us/sharepoint/ff800847