The SqlParameter is already contained by another SqlParameterCollection.

http://blog.benhall.me.uk/2007/04/sqlparameter-is-already-contained-by.html

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/%'

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

Grant Execute permissions to an sql user

use this command:

GRANT EXECUTE TO username

Login failed for user ''. The user is not associated with a trusted SQL Server connection

http://support.microsoft.com/kb/555332

Create new GUID in SQL

http://www.dailycoding.com/Posts/generate_new_guid_uniqueidentifier_in_sql_server.aspx

the function name is not a recognized built-in function name

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/66a6e3db-3ec6-4214-9d2f-a6a532a37db5

Grant EXECUTE permissions to a user SQL 2K/2K5

http://www.sqldbatips.com/showarticle.asp?ID=8