VS 2010 Test Controller / SQL Server 2012 - Could not find stored procedure 'sp_dboption'

While configuring VS 2010 Test Controller with SQL Server 2012 as Load Test Repository, I was getting an error:

Microsoft.VisualStudio.TestTools.ConfigCore.TestControllerHelper.CreateAndUpgradeLoadTestSchemaIfRequired(String loadTestConnectionString, String directoryContainingSchemaFile)
E, 2012/11/26, 09:35:41.787, Microsoft.VisualStudio.TestTools.WebStress.LoadTestException: An error occurred while attempting to create the load test results repository schema: Could not find stored procedure 'sp_dboption'.
Could not find stored procedure 'sp_dboption'.

Found the same issue when I tried to create the Load Test Repository manually by executing the script C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\loadtestresultsrepository.sql

Then I looked for the corresponding VS 2012 script on a different machine at C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\loadtestresultsrepository.sql which worked.

Looking at the difference, the fix was to replace exec sp_dboption with ALTER DATABASE

Example:

Replace exec sp_dboption N'LoadTest2010', N'autoclose', N'false' with ALTER DATABASE [LoadTest2010] SET AUTO_CLOSE OFF

VS 2012 - Retain Out Folder / Deployment Directory

Found a thread on MSDN forum on how to retain the Out folder or deployment directory for successful test runs in VS 2012.
See http://social.msdn.microsoft.com/Forums/en-US/vsunittest/thread/e99b85d9-fe59-4470-be87-036c0744fe73

Visual Studio 2012 RC – Manage Test Controllers

Unlike Visual Studio 2010, Manage Test Controllers option is not available under Test->Manage Test Controllers

There are three options to go to Manage Test Controllers.

The first option is the same which is available in Visual Studio 2010. You can open the Test Settings file and go to Roles Tab

The second option is a newly available in Visual Studio 2012. Open the Load Test and click on Manage Test Controllers

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The third option is a also newly available in Visual Studio 2012. Open the Load Test, right click on it and select Manage Test Controllers