question

Naveed avatar image
Naveed asked

SQL procedure not working through c# code

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

querystored proceduressqlserver-2012managment studio 17.3
10 |1200 characters needed characters left characters exceeded

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

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered

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

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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