ASP.Net: SQL Insert query not being called

I have a webpage uses ADO.Net that calls a stored procedure and passes variables to insert an item. Within the webserver, this works, however within the production server it is not working. Is there a开发者_StackOverflow社区nyway to look at the SQL Server and see if it is returning an error?

What does "is not working" mean? How do you know that the ASP.Net code is calling anything? Is it possible that the connection string is pointing to the wrong place? Don't you have the ability to put try / catch in the code that calls the stored procedure, and output or log any errors? I would tell you to run profiler or check the SQL Server error log, but I'm not convinced your code is connecting to a server at all, never mind the right one. The place to start debugging this is in your app, not in SQL Server. Verify that you're connecting to the right database and that you are actually entering the code that is calling the stored procedure. If it's still "not working" then you need to narrow down what that means. Either it works or you'll get an error message (unless you just have an empty catch{} handler).

After deep investigation, it was an error on my part and the user. Apologies for the vagueness