๊Update ntext With replace Function

UPDATE [db_name].[dbo].[db_table]
SET [column_name]= CAST(replace(CAST(column_name as NVarchar(MAX)),'text_original','text_toreplace') AS NText) WHERE [column_condition]= [condition_value]

Best Free Software For Your Personal Computer

Create PDF

PDFCreator
http://www.pdfforge.org/pdfcreator

Notepad (Alternative)

Notepad++
http://notepad-plus-plus.org

Download Manager

Free Download Manager
http://www.freedownloadmanager.org

Image Viewer

XNView
http://www.xnview.com
IRFANVIEW
http://www.irfanview.com/

You can suggest more. but for now this is all I try and work well With my Windows 8.1, Widows 7 and Windows Server 2012.

Free tool for Web Developer

Fiddler2
http://www.fiddler2.com

W3C Validator
http://validator.w3.org/

http://xdebug.org/

http://home.snafu.de/tilman/xenulink.html

http://notepad-plus-plus.org/

https://addons.mozilla.org/en-US/firefox/addon/web-developer/

http://colorcop.net/

http://getfirebug.com/

Free use full Opensource for Bug Tracking and Blogger

I Like to use PHP and .Net so this my choice.
Bug Tracking

ASP.NET

BugNET
http://www.bugnetproject.com

BugTracker.NET
http://www.ifdefined.com/bugtrackernet.html

PHP

Mantis Bug Tracker
http://www.mantisbt.org

Blogger
BlogEngine.NET
http://www.dotnetblogengine.net