text datatype

[stewglyn]

I am planning on storing word documents in sql server. I have been told that the text datatype the 2gb thing)does not actually store the objects but just provides a pointer to them. Does this mean I'll have to store the documents somewhere on disk and provide pointers in the actual text field? If this is true why is it 2 gigs??

yours confused

stewart

 

[dbtech]

Check this links

Image

http://www.sqlmag.com/Files/09/20461/Figure_01.gif

Answer to ur question abt pointer

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20461

Try this example

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20460

dbtech