Migration from SQL 6.5 to SQL 2000

We are migrating our SQL 6.5 application to SQL 2000 & having some difficulties for one Stored procedure . It is failing . Is there any problem
with "TINYINT" ? . Same stored procedure is working fine in SQL 6.5.

We are getting error msg while inserting some rows in following table.

tbl_sd_cmp_hier_detail
(

cmp_hier_id tinyint,
prnt_cmp_int smallint,
chld_cmp_int smallint
)

i will appriciate any help on this.Originally posted by ajayu
We are migrating our SQL 6.5 application to SQL 2000 & having some difficulties for one Stored procedure . It is failing . Is there any problem
with "TINYINT" ? . Same stored procedure is working fine in SQL 6.5.

We are getting error msg while inserting some rows in following table.

tbl_sd_cmp_hier_detail
(

cmp_hier_id tinyint,
prnt_cmp_int smallint,
chld_cmp_int smallint
)

i will appriciate any help on this.

There shouldn't be any problem with SQL 2000. I just ran this code in 2000:

USE pubs
GO

CREATE TABLE tbl_sd_cmp_hier_detail (
cmp_hier_id tinyint,
prnt_cmp_int smallint,
chld_cmp_int smallint
)
GO

INSERT INTO tbl_sd_cmp_hier_detail (
cmp_hier_id,
prnt_cmp_int,
chld_cmp_int
)
VALUES (
123,
456,
789
)
GO

SELECT * FROM dbo.tbl_sd_cmp_hier_detail
GO

I got this:

cmp_hier_id prnt_cmp_int chld_cmp_int
---- ---- ----
123 456 789

Try the code I pasted here. If that works, there is probably some other problem with the stored procedure.

Rob