Hello,

When I run the following SQL procedure I get this error:

"Implicit conversion from data type ntext to varchar is not allowed. Use the CONVERT function to run this query."

How can I use CONVERT in this procedure?

CREATE PROCEDURE sprocBlogEntryUpdateSingleItem
@id int,
@title nvarchar(200),
@body nvarchar(4000),
@categoryId int,
@datePublished datetime,
@PostedBy varchar(20),
@searchkeywords varchar(200),
@blogsummary varchar(300)
AS
UPDATE
BlogEntry
SET
Title = @title,
Body = @body,
CategoryId = @categoryId,
DatePublished = @datePublished,
PostedBy = @PostedBy,
searchkeywords = @searchkeywords,
blogsummary = @blogsummary

WHERE
Id = @id
GO

I assume this is referring to @Body being of type NVARCHAR(4000), but the body column is stored as something like varchar(400). These are incompatible.
The best solution would be to make sure the parameters are of the same type as the database fields, so you don't get any conflicts to begin with.
If you still want to use the nvarchar parameter, you can use convert in Body = @Body as so:
HTH
Phil