Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-27 : 11:57:36
|
| Fred writes "Hello,I am running SQL server 2000 on Windows 2000 server.I want to increase the size of a varchar in a column that was created with ANSI_PADDING = OFF.I am using Enterprise manager to make the modification and then choosing "Design Table". When I change the size of the varchar and then try to save my changes I get a warning:Warning: One or more existing columns have ANSI_PADDING 'off' and will be re-created with ANSI_PADDING 'on'.Why am I getting this message and is there a way to keep ANSI_PADDING from changing from off to on and still be able to change the size of the varchar?Thanks" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-27 : 13:26:08
|
| Use the profiler to look at what enterprise manager is doing then you can run those commands yourself with the correct attribute.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-27 : 13:26:55
|
| Use the profiler to look at what enterprise manager is doing then you can run those commands yourself with the correct attribute.Interesting - wonder if I got two posts for that?==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy.Edited by - nr on 02/27/2002 13:28:25 |
|
|
|
|
|
|
ansi_padding question