How to avoid 4-part naming to linked server to an Oracle database in SQL Server while using DBPro

   Scenario 1.  You have set up a linked server to an Oracle database in SQL Server 2.  You have created a synonym for an Object from the Linked Server               CREATE SYNONYM [dbo].[SynonymProducts]     FOR [Oracle_DATABASE]..[PRODRHDW].[Products] 3.  Attempt to access the synonym: Create View [dbo].[ViewProducts] AS SELECT * FROM SynonymProducts causes – TSD03006: unresolved reference…


Issue with building 2008 project from TFS build 2010

If you are building 2008 solution that contains a web project that has a 32 bit dll reference and a WDP project , on 64 bit TFSbuild 2010, you might see that when the WDP project is built its calling the 64 bit version of aspnet_compiler, but the dependant web project is build as 32…


TFSbuildServiceHost service doesnot start automatically when the build machine reboots

When build machines reboots the tfsbuildservicehost service does not start automatically and throw the below error in event log Service cannot be started. Microsoft.TeamFoundation.TeamFoundationServiceUnavailableException: Team Foundation services are not available from server http://localhost:8080/tfs/defaultcollection.Technical information (for administrator):  HTTP code 404: Not Found —> System.Net.WebException: The remote server returned an error: (404) Not Found.   at System.Net.HttpWebRequest.GetResponse()   at…


Test Class Inheritance is not working in the VS2010

If you have  a test class inheritance  and you using tfsbuild to build, you get the following error but it builds fine from IDE UTA004: Illegal use of attribute on abc.Class1. The TestMethodAttribute can be defined only inside a class marked with the TestClass attribute.    The difference between the respective behaviors in VS and…


Code Analysis Policy error “The operation could not be completed. The parameter is incorrect.”

If you change the code analysis policy settings and click on either “Merge with checkin policy” or “replace with checkin policy” in “Code Analysis Setting for Solution” in the “analyze” tab it shows the below error.“The operation could not be completed. The parameter is incorrect.” Solution: Three steps to check on client machines are:1. Select…


After upgrading VS 2008 C# project to VS 2010 project, its not building and fail with error “The type ‘ABC.Class1’ is defined in an assembly that is not referenced. You must add a reference to assembly ‘XYZ.Test1’

lf the projects were building fine in VS 2008 but after upgrade to VS 2010 project it’s not building and fail with error “The type ‘ABC.Class1’ is defined in an assembly that is not referenced. You must add a reference to assembly ‘XYZ.Test1, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null’” One important thing to check that the assemblyinfo.cs doesnot contain…


How to generate multiple .trx (test results) files and publish them with custom names while using Team Build 2008

  1.Inside your TFSBuil.Proj file overwrite the BeforeTestConfiguration target with something similar to the one below. 2. Specify the name of the test results files on 2 locations.   Inside the command line below – this will be the actual name of the file Inside the *.testrunconfig file – this will be the test run…


DBPro: How to resolve self-referencing database calls in Microsoft Visual Studio Team System 2008 Database Edition GDR Version 9.1.40413.00

  PROBLEM:  You cannot resolve  self-references through the current DBPro Project database reference implementation . For more info see:   The Data Dude Blog : Self Referencing   Example 1:   Self-referencing store procedure calls cause Warning TSD04151     Steps to replicate the problem: Create a simple DBPro project using Microsoft Visual Studio Team System 2008 Database Edition GDR Version 9.1.40413.00 …


When playing back a recorded web test with Microsoft Visual Studio Team System 2008 Test Edition SP1 the web test fails due the size of the Response

  Scenario:  You have a recorded a web test using Microsoft Visual Studio Team System 2008 Test Edition SP1. When you play back the web test it fails. The actual error message might vary.   Reason:  By default Microsoft Visual Studio Team System 2008 Test Edition SP1   captures the first 1.5 MB of the response; as a…


How to use Team Build (TFSBuild) to build a MSI package for an ASP web service/ASP Application conditionally

  Scenario: We have a VS solution that includes an ASP web service/ASP Application and a deployment project for the ASP web service/ASP Application. The solution is added to source control. We want to build the MSI package only if changes were made to the ASP web service/ASP Application . Solution: One way to achieve…