How To enable Debuging on SQL server

On the computer that is running the instance of the Database Engine, use the Windows Firewall Control Panel application to specify the following information:

·         Add TCP port 135 to the exceptions list.

·         Add the program sqlservr.exe to the exceptions list. By default, sqlservr.exe is installed in C:\Program Files\Microsoft SQL Server\MSSQL10.InstanceName\MSSQL\Binn, where InstanceName is MSSQLSERVER for the default instance, and the instance name for any named instance.

·         If the domain policy requires network communications to be done through IPsec, you must also add UDP port 4500 and UDP port 500 to the exception list.

Optionally, you can manually configure the program and port exceptions by using Windows Firewall to specify the following information:

·         Add TCP port 135 to the exceptions list.

·         Add program ssms.exe (SQL Server Management Studio) to the exceptions list. By default, ssms.exe is installed in C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE.

To add a Windows login account as sysadmin

A user who already has sysadmin privileges must execute the following:

         sp_addsrvrolemember 'Domain\Name', 'sysadmin'

where Domain\Name represents the Windows login account.

Note:       By default, Windows administrators on a computer that is running SQL Server are SQL Server sysadmins on that computer.

MSSQL backup restore method on MSSQL management studio

Following is the one of the Backup restore method on MSSQL server

Open Microsoft SQL Server Management Studio and login with admin privileges.

Expand database server name -- > databases -- > Right click select New Database as shown below.










Then it will redirect to the new DB creating window as shown below window, new DB name at database name and click ok (here can see where data files will store under path column).

 

The new DB will add to the list of databases as shown below.

To restore the backup file Right click on test (new ) database à Tasks à Restore à Database, as shown below

Then it will redirect to restore database-test window as shown below.

       1.Database name

 2. Select From device (need to be chose from where you are going table the backup file)

 3.  By click on browser button select database backup file.

 4.  Then it will add to select the database backup sets to restore section and check the box as show below.

 5.  The click on options.

Then below window will appear

6.       Check the BOX Overwrite the existing database

7.       Select the test database “mdf” file path, By Right clicking on DBàppropertiesàfileàright side plan UNDER database files section under path column “mdf” file can find(or while creating new DB under path column “mdf” file path can be find as above screen in this post)

8.        Select the test database “ldf” file path, By Right clicking on DBàppropertiesàfileàright side plan UNDER database files section under path column ”ldf” file can find(or while creating new DB under path column “ldf” file path can be find as above screen in this post)

        9.   Select recovery state as Leave database ready to use by rolling back uncommitted transaction.

10.       Then click on Ok, then restoring process will start, once restoring complete the completed successfully window will appear click on OK.

how to use Selenium RC.

Wizzard,
For example for java:

1.Download Selenium RC from openqa site.
2.Start any java IDE.
3.Create new project.
4.Add to your project classpath selenium-java-client-driver.jar
5.Record your test to from Selenium IDE and translate it to java code (Selenium IDE has automation translation feature).
6.Look for example tests in \selenium-remote-control-0.9.0 java\source\test\java\com\thoughtworks\selenium
and create your test using examples.
7.Run selenium server from console (You need initialized java environment variable to do this) like: java -jar selenium-server -proxyInjectionMode.
8.Run your test in IDE.
9.Enjoy..

How to install selenium IDE on firefox

You need to:
1. Install Mozilla Firefox first.
2. Go to openqa.org and click on the Selenium IDE link.
3. Click on the latest installable version available and just wait for it to install.
4. You can access Selenium IDE in Mozilla from Tools-> Selenium IDE.