SQL procedure not working through c# code

Question

question

Naveed asked May 13, '18

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

query stored procedures sqlserver-2012 managment studio 17.3

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

ThomasRushton answered May 13, '18

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.

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.