Hi Newbie here

**moggy4** · Mar 17, 2013 11:24

Hi
I kee getting this error from my msdb, i am not to sure as to how to proceed any help welcome.

Code ASP:

NSERT INTO UserT (FirstName,LastName, CompanyName, eMail, Phone,Mobile, Fax, Address1, Address2, Region, City, zipCode, countryID, promotionCode, LoginName, Password,userTitleID,Status,Owner,DateCreated,LastVisit) 
VALUES('*******','','dereo@gmail.com','00442920689666','','','' ,'' ,'','','null',246 ,null ,'panoramanew','3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D',1,0,2,getDate(),getDate())
System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. 
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) 
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) 
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) 
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 
at MyFunc.Functions.ExecuteSQL(String str_sql) in c:\inetpub\vhosts\*******.co.uk\********\App_Code\Functions.cs:line 188
DB ERROR occured

**Mittineague** · Mar 17, 2013 23:07

Hi moggy4, welcome to the forums,

My guess is the key portion of interest in that rather long message is
"String or binary data would be truncated"

i.e. One (and maybe others?) of the VALUES you are trying to INSERT into a field is too long.

Check your SCHEMA against those values and you should hopefully be able to spot it.