Skip to main content

We have a production system which we packaged and deployed back to a dev server. I copied the database to our dev SQL but didn't copy the stored procedures. I have since added the stored procedures and added a new one. When I go to that service instance in Smart Object Tester there are no Stored Procedures listed. I can add a table and after a refresh I see it in the list of tables but no stored procedures were found. Furthermore the SmO's bound to the original procs only show a : in their ServiceObject method bindings, it looks like they've lost the bindings.

 

I assume we can redeploy the broken SmO's but what about the missing stored procedures? How do I get those to show up again?

 

Thanks In Advance.

have you tried giving the account used to register the SQL service instance full permissions on the custom db?


Reply