I'm afraid this is a sql server question. I want to
update a column in a table in design mode.
I'm trying to change the data type (char) length from
30 to 50 characters. There is data that
already exsits in the table (over 10000 rows). When I
click on save I get a message which says:
'User' table
- Warning: One or more existing columns have
ANSI_PADDING 'off' and will be re-created with
ANSI_PADDING 'on'.
- Warning: The table was created with ANSI_NULLS 'off'
and will be re-created with ANSI_NULLS 'on'.
Not sure if by saving the changes I will loose any
data. Can anybody help
Best regards,
cfcoder
___________________________________________________________ALL-NEW Yahoo! Messenger - sooooo many all-new ways to express yourself http://uk.messenger.yahoo.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
