Stored procedure not found error after moving database

0 Likes

Problem:

Stored procedure not found error after moving database

Resolution:

  • Product Name: StarTeam
  • Product Version:?NA
  • Product Component: NA
  • Platform/OS Version: All Supported OS

Description:
Stored procedure not found error after moving database



Answer/Solution:
First of all, check to see if the problematic stored procedure(s) are there. If they are, make sure that the owner of these stored procedure(s) is "dbo". If they are not in the target database but they are in the source, then you should again restore the source database only this time do a differential restore. This will restore from the source database what is missing in the target database.



Author: Levi Bowman

Old KB# 27395
Comment List
Related
Recommended