MS SQL What data type to use.

[PaulBeaul]

I need to add a field in to a MS SQL table. The field is apx 44,000 char long. I tried to add it to a text field but query reports back that the Maximum length is 128. I thought that I could go up to 2,146,483,647 chars. Any help please!

Thanks

Paul

[MAK]

use master
go
sp_configure "max text repl size",2147483647
go
reconfigure with override
go