CREATE TABLE [dbo].[Messages](

[MessageID] [int] IDENTITY(1,1) NOT NULL,

[MessageType] [varchar](50) NULL,

[MessageText] [varchar](5000) NULL,

[MessageSubject] [varchar](50) NULL,

[Status] [bit] NULL,

[Username] [varchar](100) NULL,

[DateCreated] [datetime] NULL,

[DateModified] [datetime] NULL,

[ModifiedBy] [varchar](100) NULL,

CONSTRAINT [PK_Messages] PRIMARY KEY CLUSTERED

(

[MessageID] ASC

)WITH...

ALTER PROCEDURE [dbo].[usp_MessageBoard_InsertMessage]

@Username varchar(100),

@MessageType varchar(50),

@MessageText varchar(5000),

@status bit,

@DateCreated datetime,

@DateModified datetime,

@ModifiedBy varchar(100),

@Results varchar(100) Output

AS

INSERT INTO Messages ( MessageType, MessageText, Status, Username, DateCreated, DateModified, ModifiedBy )

VALUES ( @MessageType, @MessageText, @status, @Username,...

Thanks Bhose,

The parameter datatype is also varchar(5000) and i am...

Yes it is varchar(5000) and db is sqlserver2000. Can u tell me the maximum size the varchar can hold. Thanks in advance