Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

updatetext writetext in full recovery mode Expand / Collapse
Author
Message
Posted Wednesday, November 12, 2008 10:54 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 23, 2010 11:36 PM
Points: 305, Visits: 888
Hi Folks,

has anyone experienced any problems using updatetext or writetext on an ntext field in full recovery mode for a database.


The reason why I am asking is because the msdn help has examples of turning the full recovery mode off before using updatetext, writetext and I read somewhere the functions use a lot of log space.
Post #601858
Posted Wednesday, November 12, 2008 11:38 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:20 PM
Points: 3,122, Visits: 11,401
If you can, convert your ntext column to nvarchar(max), and you won't have to worry about updatetext or writetext. You can just use regular string functions and operators.

Post #601868
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse