Hello,
I am passing parameter values to stored procedure in datacube.
In QueryAudit, I can see all parameters are getting passed to datacube and sp correctly. This operation inserts record from dashboard to database on Click event.
On insert, table has some trigger which is getting executed. I am trying to pass Logged in user information from dashboard to database table, when trigger is enabled, I find that user details are not getting inserted but other column information is getting inserted.
When I disable trigger on tables, user information is getting stored in database table properly. Trigger don’t have any logic related to user info. What might be reason that is denying to insert Userinfo when trigger is enabled?
Unable to insert Logged in user info to database
all i can say is a never meet saw a database trigger that was helpful or useful.
my SQL admin style is make the Application do the things you normally would put in a trigger and just dont have triggers. in MS SQL default value is ok.
in this case the application is your stored procedure.
Hi @Prashant - I understand you were working with Dundas support to solve the issue. May i ask you to post your resolution?