Expected stored procedures are missing
The information in this article applies to:
Visual Studio 2005 Team Foundation Server
Visual Studio Team System 2008 Team Foundation Server
SQL Server 2005 and SQL Server 2008
Data-tier server
Health check
Preinstall check
The Best Practices Analyzer tool for Team Foundation Server queries the database instance for Team Foundation to determine the count of stored procedures for each database. An error appears if stored procedures for a specific database are missing.
Note
The tool cannot check the version number, size, or any other distinguishing property of a stored procedure to determine whether the one that is installed matches the version level of Team Foundation Server that is installed on the server. Too few stored procedures might indicate a serious issue that must be addressed. On the other hand, too many stored procedures might indicate that the Team Foundation databases have been changed, either directly or indirectly.
To resolve this issue, try to repair the installation of Team Foundation Server. The repair procedure differs depending on the version of Team Foundation Server that you have installed.
For Visual Studio 2005 Team Foundation Server, repair the Team Foundation Server (databases).
For Visual Studio Team System 2008 Team Foundation Server, repair Team Foundation Server.
For more information about how to repair your installation, see the installation guide for Team Foundation. For information about how to obtain the most recent version of this guide, see Accessing the Team Foundation Installation Guide.
Required Permissions
To perform this procedure, you must be a member of the Administrators security group on the computer.
Repairing Visual Studio 2005 Team Foundation Server (databases)
To repair the databases for Visual Studio 2005 Team Foundation Server
On the computer where the databases are installed, log on to Windows by using the Setup account for Team Foundation Server (for example, Domain\TFSSETUP).
Open the Start menu, point to Control Panel, and then click Add or Remove Programs.
Click Microsoft Visual Studio 2005 Team Foundation Server, and then click Change/Remove.
On the Maintenance Mode Options page, click Repair or Reinstall, and then click Next.
On the Ready to Install page, verify the information, and then click Install.
The Maintenance - Repair/Reinstall page appears.
On the Maintenance - Setup Complete page, click Finish.
If these steps do not resolve the issue, uninstall the service pack for Team Foundation Server if it has been installed, and then reinstall the service pack.
Repairing Visual Studio Team System 2008 Team Foundation Server
To repair Visual Studio Team System 2008 Team Foundation Server
Log on to the application-tier server.
Open the Start menu, point to Control Panel, and then click Add or Remove Programs.
Click Microsoft Visual Studio 2008 Team Foundation Server - LOC (where LOC is the three-letter locale for the installed product), and then click Change/Remove.
On the Maintenance Mode Options page, click Repair or Reinstall, and then click Next.
On the Team Foundation Server Service Account page, examine the type of account that is used for installation.
If Use a system account is specified, click Next.
If Specify an account is specified, type the Password for the specified account, and then click Next.
On the Reporting Services Data Source Account page, examine the type of account that is used for installation.
If Use Team Foundation Server service account is specified, click Next.
If Specify an account is specified, type the Password for the specified account, and then click Next.
On the Ready to Repair page, click Repair.
The Maintenance - Repair/Reinstall page shows installation progress.
You might be asked to specify the location of the original installation media.
On the Maintenance - Setup Complete page, click Finish.
When prompted, click Restart Now, and wait for the server to restart.
See Also
Other Resources
Issues That Relate to SQL Server and the Team Foundation Database