Partager via

Unexpected stored procedures were found

  • Article

  • 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. A warning appears if the count of stored procedures indicates additional, unexpected stored procedures.

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 installed on the computer. Too few stored procedures might indicate a serious issue that you should address. On the other hand, too many stored procedures might indicate that the databases have been changed, either directly or indirectly.

To restore all procedures to their installed state, repair the installation of Team Foundation Server. For more information, see Expected stored procedures are missing.

See Also

Tasks

Expected stored procedures are missing

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database