my dev server smartobject is getting data from stored procedure which has a temp table
and smo is returning list method in smo tester which is correct
after deploying to UAT, it returning execute method in smo tester which is generating error
how can i make UAT smartobject to return list method too like Development
Hi PS_K2,
Can you please attach a screenshot of the error you are seeing, as well as the method that is currently getting returned for this SmartObject in the Tester tool?
Additionally, are there any differences between the stored procedure in Dev and UAT? If you have made changes to this stored procedure on development, but not on UAT, you will need to apply those same changes to UAT and then refresh the SQL Server service instance on that environment.
Regards,
Emily
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.