SQL procedure not working through c# code

Question

Question by Naveed · May 13, 2018 at 06:48 PM · query stored procedures sqlserver-2012 managment studio 17.3

There is some command which is working fine in SQL management studio 2016 but not working in when we called this procedure through c# code

0

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2018-05-13T18:52:23Z

Answer by ThomasRushton · May 13, 2018 at 06:52 PM

Any error messages? Without any actual error messages, it's hard to know where to start.

(1) Does your application have the rights to execute the stored procedure?

(2) Is your application in the right database?

(3) Is your stored procedure in the right database on the right server?

(4) does your application have different connection settings to those in SSMS? (probably...)

(5) Is the query timing out from the application, but OK in SSMS?

(6) Is it bringing back different / incorrect results?

Try http://sommarskog.se/query-plan-mysteries.html - this has some solutions to some of the above problems.

0 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.