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.
Livin' down on the cube farm. Left, left, then a right.