SQL REPLACE

Update tbl_mytbl
Set [Content]=convert(ntext,REPLACE(convert(varchar(8000),[Content]),'ddd/pdf/','Documents/'))
where Content LIKE '%ddd/pdf/%'

REPLACE for nTEXT datatype

Update mytable
Set [Content]= cast(replace(cast([Content] as nvarchar(max)),'myfolder/pdf/','Documents/') as ntext)
where Content LIKE '%myfolder/pdf/%'

TFS Team Foundation Build

Publish website using team build:

http://blogs.msdn.com/nagarajp/archive/2005/10/21/483697.aspx
http://social.msdn.microsoft.com/Forums/en-US/tfsgeneral/thread/bf3da82d-6eda-4f36-9753-b63e98a72909

OTHER":

http://blogs.msdn.com/buckh/archive/2007/08/14/tfs-2008-a-basic-guide-to-team-build-2008.aspx
http://blogs.msdn.com/angelab/archive/2008/03/03/more-how-do-i-videos-for-tfs-2008.aspx

DNN Forums Module - Attachments

http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/7/threadid/344393/scope/posts/Default.aspx

Configuring the forum module - DNN

http://www.alentus.com/hosted-applications/dnntour/HelpForumConfigure.asp

URL Rewriting in .NET

http://msdn.microsoft.com/en-us/library/ms972974.aspx

http://weblogs.asp.net/scottgu/archive/2007/02/26/tip-trick-url-rewriting-with-asp-net.aspx

http://www.15seconds.com/Issue/030522.htm

http://www.simple-talk.com/dotnet/asp.net/a-complete-url-rewriting-solution-for-asp.net-2.0/

Invisible columns inaccessible in Gridview

http://stackoverflow.com/questions/638461/bound-column-in-asp-grid-view-when-invisible-cannot-be-accessed

Using relative urls in stylesheets

The urls in the stylesheet are with reference to the css file

http://stackoverflow.com/questions/940451?sort=oldest#sort-top

String or binary data would be truncated.

I was getting this error when i was trying to delete some rows from the table.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119861

Use relative paths in Master pages

<link rel='stylesheet' type='text/css' media='print' href='<%= BaseURL %>/styles/print.css' />

do the same for js files etc. e.g

<script src="<%=XYZ.ABC.DRR.Settings.SiteStandardRoot%>WebMods/Themes/MyTheme/scripts/AC_RunActiveContent.js" type="text/javascript"></script>