x

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??

more ▼

asked Mar 04, 2010 at 01:40 PM in Default

Shaner gravatar image

Shaner
46 1 1 1

Can you post the table script please?
Mar 04, 2010 at 01:49 PM Gianluca Sartori
can you post your table definition, and the code you are using to insert or update...
Mar 04, 2010 at 01:50 PM Kev Riley ♦♦
Discovered my own problem. I forgot to update the Triggers. Thanks anyway
Mar 04, 2010 at 02:22 PM Shaner
(comments are locked)
10|1200 characters needed characters left

2 answers: sort newest

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

more ▼

answered Mar 04, 2010 at 02:23 PM

Shaner gravatar image

Shaner
46 1 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, 2010 at 05:07 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

Are you sure that the update worked?

Can you generate the script of the table to see if the change has been commited?

more ▼

answered Mar 04, 2010 at 02:17 PM

mabc360 gravatar image

mabc360
57 1 1 1

Discovered my own problem. I forgot to update the Triggers. Thanks anyway
Mar 04, 2010 at 02:22 PM Shaner
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x9

asked: Mar 04, 2010 at 01:40 PM

Seen: 3349 times

Last Updated: Mar 04, 2010 at 01:40 PM