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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2008-08-05 : 07:28:24
|
| while iam execution test sp host name is getting inserted but from front end some execution error is coming.can any one help how to handle?Create procedure as testasbeginset nocount oninsert into user_access_report(report_name,userid,access_date)select 'Travel Expenses Report',host_name(),getdate()set nocount offend |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-05 : 08:23:35
|
| What is the error you are getting?MadhivananFailing to plan is Planning to fail |
 |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2008-08-05 : 08:33:50
|
" Error Executing Sql Statement" error is thrownquote:
Originally posted by madhivanan
What is the error you are getting?MadhivananFailing to plan is Planning to fail
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-05 : 08:39:16
|
quote:
Originally posted by sent_sara
" Error Executing Sql Statement" error is thrownquote:
Originally posted by madhivanan
What is the error you are getting?MadhivananFailing to plan is Planning to fail
How did you execute this from front end?MadhivananFailing to plan is Planning to fail |
|
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2008-08-05 : 09:49:24
|
front end ERPquote:
Originally posted by madhivanan
quote:
Originally posted by sent_sara
" Error Executing Sql Statement" error is thrownquote:
Originally posted by madhivanan
What is the error you are getting?MadhivananFailing to plan is Planning to fail
How did you execute this from front end?MadhivananFailing to plan is Planning to fail
|
|
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2008-08-06 : 01:10:37
|
quote:
Originally posted by sent_sara
front end ERPquote:
Originally posted by madhivanan
quote:
Originally posted by sent_sara
" Error Executing Sql Statement" error is thrownquote:
Originally posted by madhivanan
What is the error you are getting?MadhivananFailing to plan is Planning to fail
How did you execute this from front end?MadhivananFailing to plan is Planning to fail
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-06 : 02:25:42
|
| Can you post the code on how you are calling the procedure?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
host_name problem