Skip to main content

Hi All,


I want to create the smart object to fetch some details from the database. We have created the stored procedures and want to use them in Smart Object.


When I register the service in the service broker using SourceCode.SmartObjects.Services.DynamicSQLSPService.dll latest version, I am not able see any of my stored procedure created in the database. However, the same thing we have done for another database and there we are able to see all the procedures while configuring the service. Also, we are able to create the smart objects on that database.


Can you please let me know if I am missing something. It is working for one database and it is not working for the other database.


Any help will be highly appreciated.


Thanks & Regards


Ajay Gangwar 

Hi,


Does all your store procedure start with "sp_" ? If it's the case, the service doesn't show these store Procedure because it is considered as system store procedures.


HTH


Reply