Wednesday, October 28, 2009

Deleting a TFS Project

I spent part of my day today in Team Foundation Server reorganizing. TFS is still a fairly new addition to our development processes and no one is the true expert to whom I could go with a problem. I wanted to delete one of the TFS Projects and I could not figure out from the interface how to do it.

This is what I discovered.

You have to open the Visual Studio 2008 Command Prompt and run the following:

tfsDeleteProject /server:teamserver "Project Name"

In this example the teamserver is the name of your team foundation server.

You will get a dire warning upon entering this command that it will delete everything relating to this project and it will let you change your mind. It scared me enough that before entered "Y" as a confirmation I double-checked to make sure that all TFS databases were backed up today without a fail.

Friday, October 23, 2009

Failed to notify 'operator' via email.

I had to shuffle some SQL Servers around along with SQL Jobs. Our SMTP server has changed as well so I had to run through all SQL Jobs to make sure notifications are properly set. As I'm testing some notifications I realize that e-mails are not going through. What can be wrong?

  • Database mail enabled.
  • Test e-mail goes through.
  • Operator set up correctly.
  • Notification is set for job completion so it should go through no matter what.

However, in the History of the SQL Job, there is the following note: Failed to notify 'operator' via email.

I vaguely remember this error from the last time I was setting up a new SQL Server but I could not find my notes as to what the fix was. So I do my usual search and I find the solution.

Solution: Go to SQL Agent Properies>Alert System and enable the mail profile and restart SQL Agent.


I have been working for the University of Advancing Technology for a number of years. I started as a programmer and over the years I have transitioned into a database administrator role that encompasses everything from database programming to BI report design. As everyone else the Internet has been my greatest source for information whether I was trying to dabble in something new or running into a problem.

With this blog I am trying to give back something to the SQL community as well as document my efforts in the ever-changing world of technology. Please comment to critique, to expand on the post or simply thank me if I was able to help.