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 |
|
itsmani1
Starting Member
2 Posts |
 Posted - 2005-11-25 : 05:18:44
|
| i am very new to sql server.i have a problem that i am not able to increase the capicity of the text field. when i added new text field it just allow me the capicity of 16 that's it. if i try to modify/edit it it does not allow me to do so.http://mannan.zabvision.edu.pkM. Abdul Mannan |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-11-25 : 06:09:07
|
| Don't worry about it.. It will show you 16 only in design mode but it will accept more than 16 i.e. 2^31 - 1 (2,147,483,647) characters.Surendra |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-25 : 10:38:09
|
| That size is just the size of the field in the data row. It is a pointer to the actual text entry which is not held on the data page.When you do a select or insert it will access the text data not the pointer.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
problem with sql server : problem in table