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 |
|
eem_2055
Yak Posting Veteran
69 Posts |
 Posted - 2007-10-02 : 04:05:25
|
| Hey guys, I need your generous heart to share something with what I am experiencing. I found the error from Sql Profiler. Here is the result of my trace:/*w/o runtime*/declare @P1 intset @P1=0exec CP_glmJournalEntry_Save 1, '110802010200', 'To record PPC-Visa transaction, $4,967.39@Php46.22 select @P1/*w runtime*/declare @P1 intset @P1=NULLexec CP_glmJournalEntry_Save 1, '210204020202', 'Sample select @P1May I know if the runtime came from the stored proc or on the application itself.Moreover I want to know a lot with stored procedure. I am confusing now because there are times that runtime didn't occur. While some other times runtime occured.I hope you'll goin to help me,, thanks in advance! |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-10-02 : 12:54:23
|
| I don't really understand what you are asking.I did notice that the 2nd bit of code you posted uses 2 arguments with the stored procedure instead of the 3 arguments shown in the first bit of code. Does your sproc expect 3 arguments?-ec |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-02 : 22:22:12
|
| Take look at kb article 209050 and check resource usage on sql server. |
|
|
|
|
|
|
Stored Pro run time erorr -2147217871(80040e31)