Post reply

Restored SQL 2000 backup, stored procedures don''t work

  • May 6, 2006 at 2:42 am

    #114129

    Hello

    I have restored a SQL 2000 backup of my database, ever since my web applications are unable to use any of the stored procedures.

    I get the following error:

    Could not find stored procedure 'xxx'.

    If I use enterprise manager and go to the procedures tab the procedure appears there.

    Any ideas what is up?

    PS: The username has been changed, before the backup it was "user1" now its something else. For some reason it still shows that the procedure object is owned by "user1". Could this be the problem?

    Thanks in advance.

  • May 6, 2006 at 3:37 am

    #636401

    I have solved this problem. This was because the tables and the stored procedures were owned by the old user. I used the scripts explained on this page: http://weblogs.asp.net/owscott/archive/2004/01/30/65229.aspx and updated the object owner to dbo. This solved the problem.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply