I have tested this one:

CREATE TABLE tbl (

id int IDENTITY,

col varchar(50) CONSTRAINT CK_t1 CHECK (col not like '%[^ -~A-Z0-9]%')

)

and when i try these insert statements:

INSERT INTO tbl(col) VALUES('abc'...

Thanks so much. It worked fine. Is there a way to set arithabort on per connection in VB if I dont want to change server settings?