Clean up temporary TFS workspaces when using sql compare
Apparently SSC creates temporary workspaces when being called from SQL Compare (when using a source controlled version of the database as the source of the comparison), but it doesn't seem to clean up after itself completely. When I go to manage my workspaces in TFS, it is currently showing that I have over 50 temporary workspaces that were created by SSC. I can't swear to it, but I think this may have caused issues with our builds, as I have observed at one point that I inadvertently checked code files out to one of these temporary workspaces instead of my default workspace. I think this needs to be addressed. I would almost categorize it as a bug.
SQL Source Control 3.0 is now available which includes a fix for this issue.
TFS workspaces are created when linking to a database in SQL Source Control – from v3.0 these are deleted when the database is unlinked.
To download v3, please visit:
http://www.red-gate.com/products/sql-development/sql-source-control/