Hi there,

I ran a script on one server and it worked perfectly without a problem. Tried running the same script on different server and got this error

Server: Msg 8114, Level 16, State 4, Procedure geAcTrans, Line 0
Error converting data type varchar to int.

Here is the script

begin transaction
EXECUTE geAcTrans
0 --Transaction ID numeric(8,0),
,'' --Account ID char(12),
,'' --Hold Type char(02),
,'' --Settlement Currency char(03),
,'' --Transaction Type char(04),
,'2004-03-01' --Transaction Date From smalldatetime '2001-01-01'
,'2004-03-02' --Transaction Date To smalldatetime, '2001-01-01'
,'' --As At Date From smalldatetime,
,'' --As At Date To smalldatetime,
,'' --Reference char(20),
,0 --Batch ID integer,
,'NZD' --Currency char(03),
,'NZSE' --Exchange ID char(06),
,'' --Security char(12)
,'Y' --Exclude Reversals char(01) 'N' to include reversals, 'Y' to exclude.

rollback transaction


SQL 2K sp3
WINDOWS2K sp2 with SRP1

Has anyone has the same problem?

Please advise,

Daylinda Sanchez

Count every bump as a blessing. You either feel them because you are moving forward or because you are lying in the road creating one for someone else.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004


----------

The information contained in this e-mail and any attachments is confidential
and is intended for the attention and use of the named addressee(s) only.
Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of Chelmer Limited.

MS Sql Server LazyDBA home page