Post reply

Error number 2812 Store procedure not found

  • February 15, 2021 at 3:06 am

    #3845043

    Hi Expert,

     

    Have migrated database 'northwind' from Server A to Server B

    Server A Configuratioun- ms sql server 2012 developer edition  64 bit  windows nt 6.1  build 9200

    Server b configuration -ms sql server 2012 standard edition  64 bit  windownt 6.2  service pack 1 hypervisor

    I am able to run the store procedure on server B  exec sp_northwind_test but unable to pull into application getting error

    Error number 2812 Store procedure sp_northwind_test not found

     

    Regards

    Shree

     

  • February 15, 2021 at 3:16 am

    #3845045

    both collation is same  latin1_general_ci_as

  • February 15, 2021 at 9:49 am

    #3845135

    Please explain what you mean by "... unable to pull into application ...".

    Which application? What do you mean by "pull"?

    • This reply was modified 3 years, 9 months ago by  Phil Parkin.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 15, 2021 at 12:37 pm

    #3845194

    Hi Expert,

     

    Trying to pull from ASP.net Application

     

  • February 15, 2021 at 4:46 pm

    #3845277

    OK, no idea what's going on here. Stored procedures get executed, not pulled.

    If your application worked fine on one server but not the second, I'd suspect either a configuration error or a permissions error. But without a lot more information, it's impossible to determine.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 5 posts - 1 through 4 (of 4 total)

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