Alter size of varchar Column

I altered the size of a varchar column from 20 to 30. The alter worked ok but it still only allows me to insert or update 20 characters. What am I missing??

asked Mar 04 '10 at 01:40 PM in Default

Shaner
46 ● 1 ● 1

Can you post the table script please?

Mar 04 '10 at 01:49 PM Gianluca Sartori

can you post your table definition, and the code you are using to insert or update...

Mar 04 '10 at 01:50 PM Kev Riley ♦♦

Discovered my own problem. I forgot to update the Triggers. Thanks anyway

Mar 04 '10 at 02:22 PM Shaner

(comments are locked)

2 answers:

Discovered my own problem. I forgot to update the Triggers. Thanks anyway

answered Mar 04 '10 at 02:23 PM

Shaner
46 ● 1 ● 1

Mark this answer as correct then - maybe someone in the future will see this, and this will save them some searching (just before they facepalm themselves in a majorly epic manner)

Mar 04 '10 at 05:07 PM Matt Whitfield ♦♦

(comments are locked)