sysobject warnings in my DBPro projects 29 July 2011 Donovan-Brown Work (0) Problem My DBPro project references sysobjects and is causing build warnings for example: SQL04151: Procedure: [dbo].[aspnet_AnyDataInTables] has an unresolved reference to object [dbo].[sysobjects]. Solution Add the following DB reference to your database project: C:\Program... [More]
I can't run my scripts created by DBPro in SSMS 26 July 2011 Donovan-Brown Work (0) Problem When I try and run my deploy scripts from DBPro in SSMS I get syntax errors where variables are used. Solution Switch on SQL CMD Mode before you execute the SQL file. To enable the SQL CMD Mode select SQL CMD Mode from the Query menu in SSMS.
I need to build a project that is not supported by MSBuild 15 July 2011 Donovan-Brown Work (0) Problem My solution contains a .vdproj and it is not supported by MSBuild. Solution Call devenv from team build using InvokeProcess for .vdproj projects. Explanation This customization can be extended to build any project types not supported by MSBuild (vb6, power builder, fortran, VC++ 6, etc)... [More]
One lab machine will not connect to test controller! 22 June 2011 Donovan-Brown Work (0) Problem I have a lab environment configured with 4 machines. It is running in Network Isolation, and has workflow and test capability enabled. The testing capability fails only on one machine. Solution Adjust the binding order of your network adapters so that external adapter is first... [More]
My build agent just stopped working! 20 June 2011 Donovan-Brown Work (0) Problem My build agent state in Team Foundation Administrative Console states Ready but the icon shows stopped and I can't queue builds. Solution Either log in as the Service Account used to run the build agent or log in using any account and right click on IE and run as the Service Account.1. ... [More]
I can't run VMM and I am an admin 15 June 2011 Donovan-Brown Work (0) Problem When I run VMM I am given the error I don't have permissions to run VMM on localhost. Solution You have to have a current VMM administrator to add you to the Administrator role in VMM under Administration tab. Start VMM Click the Administration tab Select User Roles Double Click Adm... [More]
My build keeps hanging on the psexec call 14 June 2011 Donovan-Brown Work (0) Problem Calling psexec from an invoke process activity on a 2008 Server and it is hanging. Solution Upgrade to 1.98 of psexec and use the -h switch to run with the account's elevated token. Explanation If the target system is Vista or higher, the -h allows the process to get past the UAC that i... [More]
I need to attach files larger than 4KB to my work items in TFS 2010 20 May 2011 Donovan-Brown Work (0) How to increase the work item attachment size in TFS2010. [More]
Command line tool for Work Item Queries 16 May 2011 Donovan-Brown Work (0) Problem I need to script my work item query administation. Solution Use the Work Item Query Administration tool from CodePlex http://wiqadmin.codeplex.com/ Examples This will list out all the queries and the paths you need to export them wiqadmin list /collection:http://MytfsUrl:8080/tfs/defau... [More]
Full Text Error when using Search Work Items for TFS 2010 plugin 09 March 2011 Donovan-Brown Work (0) Problem Every time I run the Search Work Items for TFS 2010 plugin I get the following TF248015 error: Solution Add the account running the SQL Full-text Filter Daemon Launcher (MSSQLSERVER) service to the SQLServerFDHostUser$instance_name$MSSQLSERVER group (via computer management console) and... [More]