Post reply

updatetext writetext in full recovery mode

  • November 12, 2008 at 10:54 pm

    #383370

    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.

  • November 12, 2008 at 11:38 pm

    #897905

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply