Failed to find project file at path in CI

do a build with clean option checked

exec in Team City

you need to add exec - for example - a plain sp_rename wont work

The type or namespace name 'Blah' does not exist in the namespace 'heh.heh' (are you missing an assembly reference?)

I was getting this in a team city build because the dll was directly referenced instead of the project being referenced.

This has great consequences with release builds
As I understand it,only with a project reference is the bin created

Exception calling "DownloadFile" with "2" argument(s): "An exception occurred during a WebClient request."

means someone has a lock on one of the files

If you can't find the error in the team city log

go to the log team city creates under c:\temp in the destination server for more detailed info

team city and comments

it appears that team city removes /**/ comments and keeps -- comments in stored procedures

Table types in Team City

create a script that drops the sp's that reference the table type - drop the table type
have this run before the sp's do