Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can run a SQL Server unit test in any one of several ways, such as using various windows and the Command Prompt window.
Note
You can't run unit tests remotely.
The ways that are available to you depend on the software that you installed, as described in Run SQL Server unit tests.
Run SQL Server unit tests using Test View (Visual Studio 2010)
On the Test menu, point to Windows, and then select Test View.
The Test View window opens.
In the Test View window, select the test or tests that you want to run. By using the Ctrl key or the Shift key, you can specify discontinuous or continuous blocks of tests.
Do either of the following steps:
- Right-click the surface of the Test View window, and then select Run Selection.
- On the Test View toolbar, select Run Selection.
Run SQL Server unit tests using Test Explorer (Visual Studio 2012)
On the Test menu, point to Windows, and then select Test Explorer.
The Test Explorer window opens.
In the Test Explorer, select the test or tests that you want to run. By using the CTRL key or the SHIFT key, you can specify discontinuous or continuous blocks of tests.
Right-click one of the highlighted tests and select Run Selected Tests.
Run SQL Server unit tests from the SQL Server Unit Test Designer (Visual Studio 2010)
On the Test Tools toolbar, you find buttons to start a project with or without the debugger.
This step runs all tests in the current test run. As soon as you start a test run, the Test Results window appears and displays the progress of the test run. This display includes tests that are running and tests that have completed. For more information, see Interpret SQL Server unit test results.