Msg 2812 ''cannot find stored procedure''

• tony appleby

  SSC Enthusiast

  Points: 158

  More actions

  March 30, 2007 at 9:19 am

  #171887

  Hi all,

  I got the above msg when I try to change a col's value manually (in interprise Mgr) or using INSERT in sql query. The name of the sp was an old name associated for that table and no longer existed. I tried to refresh but nothing changed. Any one know why? or how to getrid of the msg?

  Thanks

• tony appleby

  SSC Enthusiast

  Points: 158

  More actions

  March 30, 2007 at 9:51 am

  #697886

  never mind , I found the prob. There was a trigger that references an old sp which no longer existed.