Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2010-02-25 : 05:42:39
|
| Hi,I am using sql server 2008 .We have one stored procedure which we need to call from front end (java)application by supplying some parementers(from date - to date)when we are executing this stored procedure from back end (sql server management studio) it is working fine .But when calling from application it is executing for only for some days.like if we give 1-jan-2010 to 1-apr-2010 ..it will work only for 1-jan-2010 to 20-jan-2010 only. how can we check where is the problem..can we check whole process of executing this ..like each statement ...log file ..any idea... |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-02-25 : 05:45:08
|
| Check the input parameter datatype! Is it datetime or varchar?Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2010-02-25 : 06:29:01
|
| Hi,I checked this ...this is correct ..where i can check the execution steps of stored proceduress...like from getting paramenter value form application till end ... |
|
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2010-03-04 : 02:05:08
|
| I need to generate one log file when stroed procedure got execute .like i just want to know from front end ..it is executing ..so i want to insert value of parements which was passed to stored procedure in log file ..is there any other procedure we can execute with in this stored procedure this will write value of input paramenter in the text file ...or any other way |
|
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2010-03-04 : 06:07:57
|
| Is there any idea on this ...Stored procedure is executed from backend ...like directly on database (BY DBA)but not from front end ..application ... |
|
|
|
|
|
|
Log file stored procedure