INFORMATION_SCHEMA issues

• Tobar

  SSCarpal Tunnel

  Points: 4876

  More actions

  February 26, 2014 at 1:06 pm

  #284013

  I backed-up database A and restored it as B. I just realized that all the new USPs that I have created do not show up in INFORMATION_SCHEMA.routines. The routine_catalog column, of INFORMATION_SCHEMA.routines, still says A and it probably should be B.

  I am trying to figure out how to get all the routines to show up in "routines", but more importantly I am trying to figure out how to set this up correctly. I have seen issues like this before in the forums but I cannot figure out a question that seems to get me the answers I need. Sorry about that. Hope someone can help.

  Thanks.

  <><
  Livin' down on the cube farm. Left, left, then a right.

• Tobar

  SSCarpal Tunnel

  Points: 4876

  More actions

  February 26, 2014 at 1:54 pm

  #1692424

  Never mind. My idiocy has been cured.

  <><
  Livin' down on the cube farm. Left, left, then a right.