Database Log Truncated
Mar 30, 2004
Recently we've upgraded SQL 7.0 to SQL 2000. We use a Database Maintenance Plans to backup the databases and transaction logs. Everything seems to be working, but I’m getting an error message in the event viewer that has been described in Microsoft Knowledge Base article 818202 "PRB: A'Database log truncated" Error is logged in the Event Log When you try to Backup the Transaction Log. The article describes the cause of this warning, but does not give any fix or some kind of work around. Does anybody knows what to do or may be had this problem before? Please help. Thanks a lot.
View 6 Replies
ADVERTISEMENT
Dec 18, 2001
SQL 2K sp2 on NT4 EE SP6a.
During the DTS Import operation from the production Server (SQL 7.0 SP1) to the Test Server (SQL 2K SP2) I receive the following notification error on the NT application log:
EVENT ID: 17055
Source: MSSQLSERVER
Type: Error
category: Backup
Description:18278:
Database log truncated: Database: XXX
The operation of Import succeed, but I have the "red error" on my NT application log.
Can someone help me on this?
Thank you very much.
Franco
View 1 Replies
View Related
Jul 23, 2005
Hello All,The setting is SQL server 7, on Windows NT.If the distributor can not access the log on the publisher database ( butsubscribers are not deleted yet), will the full backup of the publisherdatabase truncate the transaction log? My guess is, it will not truncate thelog.Can any one confirm please?Thanks,Mokles
View 2 Replies
View Related
Apr 21, 2008
Hi
I have an SP, which queries a table and correspondingly outputs an ntext column. Before executing this SP. I used "save results as " option under Query analyzer tool bar. So that, when ever i execute this SP I can store the value under a file. The query is executing fine , but it is truncating the output of this ntext value.
Does any body knowsfaced this issue?
Iam using sql 2000
Thanks!
Santhosh
View 5 Replies
View Related
Apr 11, 2001
Hi!
In the results of our queries, the datas in the fields are truncated to 255 chars.
Is there a parameter to change to get the entire field? Their format is varchar 8000 and the fields are longer than 255 characters in the db.
Thanks for your help.
View 2 Replies
View Related
Mar 9, 2000
Hello,
I am trying to run a query
select logid, count(logid) from temp2
group by logid
order by logid
compute sum(count(logid))
when I get the result the numbers are being truncated
eg instead of 10471066 it shows 104710 so last two digits
get truncated. Any ideas or hints appreciated.
Thanks
HP
View 1 Replies
View Related
Mar 31, 2008
say if I am doing an simple insert (50 million records) with union all into a table.... when i check it while the query is running I see some records inserted.... however, at the end i have no data... table gets truncated. Is it so because I was out of space (I checked the drives and seems like data drive is running out of space).
Thanks for ur help.
View 2 Replies
View Related
Jan 16, 2006
I am relatively new to SQL server. I am tring to send some decimalvalues to the database using a stored procedure with parameters of typeDECIMAL. Every time it inserts the values into the database thedecimals are truncated. I saw on the MSDN library that you have to setthe precision and scale values b/f you run the stored procedure. So Iset the precision to 8 and the scale to 4 and it still didn't help. Cananyone help me?
View 6 Replies
View Related
May 24, 2006
Hello,Using SQL SERVER 2000I have 4 columns with varchar(80) each that I want to concatenate.When I look at the result, it only gives me 256 characters. What am Imissing on my code?Select Cust_Number, Info = convert(varchar(1000),rtrim(line1) +char(13)+rtrim(Line2) + char(13)+ rtrim(line3) + char(13)+rtrim(line4))[color=blue]>From tableOne[/color]GoThank you for your input.Edgar
View 3 Replies
View Related
Jul 30, 2007
Hi,I am trying to generate an XML output form the database. I amexecutingselect * from Request_vw for xml autoThe output data is being truncated. is there a limit on the outputresult of an XML query?Thanks
View 3 Replies
View Related
Feb 22, 2008
I'm a newbie to Transact-SQL so I apologize if this is a stupid question. Whenever I try to divide two variables of type int, I get a result where the decimal part is truncated. Here is an example:
ALTER PROCEDURE [dbo].[DIVIDE_TEST]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE
@VAR1 int,
@VAR2 int,
@MYRESULT dec(10,5)
SELECT @VAR1 = 10
SELECT @VAR2 = 3
SELECT @MYRESULT = (@VAR1/@VAR2)
SELECT @MYRESULT
-- @MYRESULT has decimal part truncated, Returned value = 3.00000
END
Any ideas?
View 3 Replies
View Related
Jul 13, 2006
I have a problem with a NVARCHAR(MAX) parameter being truncated.
The signature of the UDF is:
[SqlFunction(FillRowMethodName = "SplitFillRow",IsPrecise=true,IsDeterministic=true,
DataAccess = DataAccessKind.None,TableDefinition = "pos INT, token NVARCHAR(10) ")]
public static IEnumerable SplitText (SqlChars input, SqlString strDelimiter)
{...
and deployed as:
CREATE FUNCTION [dbo].[SplitText](@input [nvarchar](max), @strDelimiter [nvarchar](10))
....
But it is still being truncated to 8000 characters. I tried using a sqlstring or using
([SqlFacet(MaxSize = -1,IsFixedLength=false)] on the parameter and a bunch of other things, but it is still truncated to 8000.
I am out of ideas...anyone with a tip?
Thanks
Eric
View 5 Replies
View Related
Jul 24, 2006
I'm using SQL Server 2005. I have stored procedure that selects a bunch of data from different tables and returns the results using the FOR XML clause. The problem is when I'm loading the XML, I notice that after a little over 2,000 characters, the XML string is getting truncated and thus I can't load it into an XmlDocument object. I'm also using the Microsoft Enterprise Library data access block, if that makes any difference. Here's the code:
View 1 Replies
View Related
Jul 8, 2004
I have a standard asp.net form and a single database table that I’m trying to pass data into. There are three nvarchar fields of lengths 50, 150, and 2400. Whenever I do an insert or update it truncates all data except for the first character. So if I pass “asdfasdf�, the db field will only receive “a�.
The data going from the form is correct; it gets truncated somewhere after the ExecuteNonQuery() call.
Here is the c# code:
public bool InsertCareer (DataRow row) {
SqlConnection conn = new SqlConnection(connStr);
try {
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = storedProcs[(int)StoredProcedures.Insert];
cmd.Connection = conn;
cmd.Parameters.Add("@pkCareerID", row[0]);
cmd.Parameters.Add("@jobTitle", row[1]);
cmd.Parameters.Add("@postedDate", row[2]);
cmd.Parameters.Add("@submitBy", row[3]);
cmd.Parameters.Add("@department", row[4]);
cmd.Parameters.Add("@description", row[5]);
cmd.Parameters.Add("@intranet", row[6]);
cmd.Parameters.Add("@public", row[7]);
conn.Open();
cmd.ExecuteNonQuery();
return true;
} catch (Exception ex) {
//… stuff
return false;
} finally {
conn.Close();
}
}
This is the sproc code:
CREATE PROCEDURE dbo.zak_CareersIU_sp
@pkCareerID int,
@jobTitle nvarchar,
@postedDate datetime,
@submitBy datetime,
@department nvarchar,
@description nvarchar,
@intranet bit,
@public bit
AS
IF EXISTS (SELECT pkCareerID FROM zak_Careers WHERE pkCareerID=@pkCareerID)
BEGIN
UPDATE zak_Careers SET
jobTitle=@jobTitle,
postedDate=@postedDate,
submitBy=@submitBy,
department=@department,
[description]=@description,
intranet=@intranet,
[public]=@public
WHERE
pkCareerID=@pkCareerID
END
ELSE
BEGIN
INSERT INTO zak_Careers
(jobTitle, postedDate, submitBy, department, [description], intranet, [public])
VALUES
(@jobTitle, @postedDate, @submitBy, @department, @description, @intranet, @public)
END
Please let me know if you have any ideas!
thanks
View 3 Replies
View Related
Aug 16, 2004
Hi,
I have hit a brick wall with this. My code is as below
public void fillCustomer()
{
string connectionString = "server='local'; trusted_connection= true; integrated security=sspi; database='Mrbob'";
System.Data.SqlClient.SqlConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);
string queryString = "SELECT * FROM [Customer] WHERE ([CustomerID] = @CustomerID)";
System.Data.SqlClient.SqlCommand dbCommand= new System.Data.SqlClient.SqlCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
System.Data.IDataParameter param_CustomerID = new System.Data.SqlClient.SqlParameter();
param_CustomerID.ParameterName ="@CustomerID";
param_CustomerID.Value = customerID;dbCommand.Parameters.Add("@CustomerID", SqlDbType.Int);
dbCommand.Connection.Open();
System.Data.IDataReader dataReader = dbCommand.ExecuteReader();
dbCommand.Connection.Close();
while(dataReader.Read())
{
customerID = dataReader.GetInt32(0);
date = dataReader.GetDateTime(1);
eposCode = dataReader.GetInt32(2);
}
dataReader.Close();
}
The error I am getting is
Prepared statement '(@CustomerID int)SELECT * FROM [Customer] WHERE ([CustomerID] = ' expects parameter @CustomerID, which was not supplied.
As you can see from my queryString the @CustomerID parameter is passed in. It seems as if the string is being truncated at 64 characters long. If I remove the paramter to pass the relevant infomration and pass in a customerID I know exists it works.
I am really stumped on this and would really appreciate any pointers
View 1 Replies
View Related
Feb 7, 2005
Hi! When I run a select statement, it would retrieve a product description. In some rows, it is long. Consequently, the product description was truncated. Did anybody have resulotion for this issue?
View 7 Replies
View Related
May 27, 2006
My SQL Server 2000 database log was full (2MB) and I am unable to add new column to a table. So that I follow this article to truncate my log file to 1MB. It works. But when I add a new column to a table after that. The log file went back to 2MB in size and I got the "the log file is full" error message again for the operation. BTW, my reovery mode was set to "Simple". I don't understand how the save table operation can recover my change on log size. What should I do to "permanently" truncate my log?
http://www.support.microsoft.com/?id=272318
I did this:
DBCC SHRINKFILE (myDB_Log, 1)
BACKUP LOG myDB WITH TRUNCATE_ONLY
DBCC SHRINKFILE (myDB_Log, 1)
View 1 Replies
View Related
Oct 6, 2006
Hi
I have a table Test a execute this below query
truncate table Test
I want to retrive records of Test table .How can i do.
Ranjeet Kumar Singh
View 10 Replies
View Related
Dec 14, 2006
My table has got 67K records but the tool is showing just 100 records other records are getting truncated. Now what i have to do in SQL statement to view the other records starting from 100 to 1000?
View 2 Replies
View Related
Mar 1, 2006
"String or binary data would be truncated"Can MS SQL automatically do the truncation?--John MexIT: http://johnbokma.com/mexit/personal page: http://johnbokma.com/Experienced programmer available: http://castleamber.com/Happy Customers: http://castleamber.com/testimonials.html
View 6 Replies
View Related
Jul 20, 2005
The transaction log in a database in our SQLSERVER-2000 server hasgrown to 16GB. I cannot shrink the transaction log manually because itsays that the entire 16GB log size is not free. This is strangebecause we backup the transaction log every hour, and that should havetruncated the transaction log, and should have limited the size of thetransaction log; somehow, the entire transaction log is still markedas being used.I was under the impressionI believe that must have something to do with the fact that thedatabase is a part of our nightly replication. The reason is that whenI tried the following commands, I got that error message:checkpointdump transaction isprod with no_logThe log was not truncated because records at the beginningof the log are pending replication. Ensure the Log ReaderAgent is running or use sp_repldone to mark transactionsas distributed.What does this mean? How can I get away from this mess?Thanks.Jay Chan
View 5 Replies
View Related
Jan 20, 2007
I am trying to send a large string to my table where I have typed the field as "text". The data is truncated ( I am only sending about 5kb and it is being truncated to about 4kb). I am using SQL 2000.
My web page is classic.asp and I am sending a parameterized query to my stored procedure.
This is the relevelant code for the parameter I'm sending:
objCmd.Parameters.Append = objCmd.CreateParameter("@PostBody",adLongVarChar,adParamInput,20000,PostBody)
This is the typing in my stored proc: @PostBody text,
I can either INSERT or UPDATE using Query Analyzer and the data is NOT truncated.
Wondering if it was my parameterized query that was causing me trouble, I rewrote the code to send the SQL upfront (skipping the stored proc), and the calling the stored proc from my .asp page passing in the parameters in a string. All three ways are truncating the data.
I have isolated that the truncation is happening on the way in, not on the way out.
Because I can successfully insert/update with QA, I'm wondering if there is some IIS issue that is causing the truncation. But I don't manage our IIS server so I really don't know much about that end of things.
I have been researching this issue for two days with no luck. Any ideas will be greatly appreciated!
View 4 Replies
View Related
May 29, 2006
Sometime when I€™m using the Data Flow designer I create a task that displays a red circle with a white €œx€? in it. Usually, but not always, the tooltip appears explaining the problem. Sometimes when the tooltip appears I can€™t read the message fully because it is truncated. What can I do in that case?
Barkingdog
View 1 Replies
View Related
May 7, 2008
I have an Oracle table which contains a LONG column and I need to migrate the data from this table using SSIS to a table in SQLServer. The column in SQLServer is defined as nvarchar(MAX). This works until I changed the Oracle table to a view. The columns in the view are defined exactly the same as the source table except that it uses a database link to point to the table in a different schema. When executing the data flow task using the view, it gives me the following error message -
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-01406: fetched column value was truncated ".
The error happens only on views with LONG column. Views with only varchar or numeric data types work fine.
Why does it work with a table but not a view which contains a LONG column?
Any suggestion is greatly appreciated.
View 3 Replies
View Related
Nov 29, 2007
Hello all,
I have a COM object (written in VB6) that uses the Microsoft Remote Data Object 2.0 (MSRDO20.dll) to perform non-exotic SQL statements (i.e. SELECTs, INSERTs, UPDATEs and DELETE).
I am using SQL Server 2000 with SP4.
Some of our INSERT statements are being truncated within SQL2K...
We have turned on the SQL Profiler to verify this. Using our own logging mechanism, we log the INSERT SQL being passed to SQL2K immediately before executing the MS SQL statement and our log shows that the INSERT statement is indeed correct. However, we get a SQL error back due to malformed SQL. The SQL Profiler shows that the last 10 bytes have been truncated from the INSERT SQL within SQL2K.
The INSERT statement that we are passing is in the following form...
INSERT (column names...) VALUES (...)
There are embedded CRs (0x0D) in the INSERT.
The length of the INSERT being passed to SQL2K is 2243 bytes.
The length of the INSERT from the Profiler is 2233 bytes (the last 10 bytes were truncated).
Here's a brief glimpse of our VB6 code...
Dim Cn as rdoConnection
Dim sSql as String
Set Cn = New rdoConnection
Cn.Connect = "DSN=FrontOff;UID=Front;PWD=Front;DATABASE=FrontOff;"
Cn.CursorDriver = iCursorDriver
Cn.LoginTimeout = 5
Cn.QueryTimeout = 5
Cn.EstablishConnection rdDriverNoPrompt
sSql = "INSERT INTO PLU €¦"
Cn.QueryTimeout = 300
// Log sSQL to our logging mechanism...
Cn.Execute sSql, rdExecDirect
So, is there a maximum length for a SQL statement in SQL2K???
Any help would be appreciated.
TIA!!!
View 1 Replies
View Related
Aug 9, 2006
Hi Folks,
After I inserted a row in my Database (row 27) I started getting this error when I try to insert, update or delete the record in the database.
I've searched about the error on google and it says that I should have a field that crossed the limit of characters.
I have only the autoincrement field, two varchar fields and a text field, neither one of the varchar fields crossed the limit, they arent even close. I found in google that one solution would be turn the field that is having problems in a text field, but the only field that actually can be causing the problem already is of the text type.
The exact error I get on VS 2005 when trying to change something in the row 27 is:
"No row was updated.
The data in row 27 was not committed.Error Source: .Net SqlClient Data Provider.Error Message: String or binary data would be truncated.The statement has been terminated.
Corret the errors and retry or press ESC to cancel the change(s)."
I need some help guyz, see ya, hugs.
View 3 Replies
View Related
Jan 21, 2007
Hi Guys, I'm trying to save the data into 2 table when i click the button. But it pops out this error: String or binary data would be truncated. The statement has been
terminated. Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code. Exception Details:
System.Data.SqlClient.SqlException: String or binary data would be
truncated. The statement has been terminated.Source Error:
Line 116:Line 117: Sqlinsert.Connection.Open()Line 118: Sqlinsert.ExecuteNonQuery()Line 119:Line 120: Sqlinsert.Connection.Close() I Don't know what it means so i paste my codes regarding the button & the redline Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
'add the data into shopper
Dim strsqlcmd As String
Dim strName, straddress As String
Dim strContact, strEmail, strPw As String
Dim strIC As String
strName = txtName.Text
straddress = txtAdd.Text
strEmail = txtEmail.Text
strContact = txtboxContact.Text
strIC = txtIC.Text
strsqlcmd = "Insert Into Shopper (Name, Address, Contact, Email, IC) Values (@Name, @Address, @Contact, @Email, @IC)"
SqlCommand1.CommandText = strsqlcmd
With SqlCommand1.Parameters
.Add("@Name", strName)
.Add("@Address", straddress)
.Add("@Contact", strContact)
.Add("@Email", strEmail)
.Add("@IC", strIC)
End With
SqlCnt.Open()
SqlCommand1.ExecuteNonQuery()
SqlCnt.Close()
'add the data into the presc
strsqlcmd = "Insert Into Prescription (Name, Address, Contact, Email, IC) Values (@Name, @Address, @Contact, @Email, @IC)"
Sqlinsert.CommandText = strsqlcmd
With Sqlinsert.Parameters
.Add("@Name", strName)
.Add("@Address", straddress)
.Add("@Contact", strContact)
.Add("@Email", strEmail)
.Add("@IC", strIC)
End With
Sqlinsert.Connection.Open()
Sqlinsert.ExecuteNonQuery()
Sqlinsert.Connection.Close()
' go the add item
Response.Redirect("NewPrescItem.aspx") why my sqlinsert.excutenonquery will have this error? and what is this error really means? Thanks in advance
View 3 Replies
View Related
Sep 12, 2007
I am currently developing a simple program that will upload ms-word documents to a database so users can view them within the department.
The program worked prefectly while using sql 2005 with the these fields:
FormId intFileName nvarchar(50)FileBytes varbinary(Max)
This was done in unit testing, now in system testing there is a difference.
A slight downgrade in the database and server software!
We are using sql 2000 on a 2000 server and the FileBytes datatype had to change to the following:
FormId intFileName nvarchar 50 FileBytes varbinary 8000
There is no 'Max' option in sql 2000 for the datatype varbinary.
So when the insert is perform, we get this error message:
String or binary data would be truncated.The statement has been terminated.
I am guessing it has something to do with FileBytes, because this is the only thing that changed.
I just don't know how to solve the problem.P.S.The application is in ASP.NET 2.0
Thanks,
xyz789
View 4 Replies
View Related
Oct 8, 2007
I keep getting the error "String or binary data would be truncated." when I try to insert data into SQL Sever 2005 from an ASP.net page. Having searched thoughout the web, I know this is generally caused because one of the values being inserted is bigger than the size of the field it's going into. But, I have tested this out in many different ways, and this is not what's causing the problem.
I have tried doing the insert as a SQL statement and using the "ExecuteNonQuery" command. I have also tried running this through a stored procedure. Neither works. In both situations, I have captured the TSQL statements via SQL Profiler and run them in a query window. In both cases, the statements work just fine in a query window.
When I try to do the insert via a stored procedure, all of the statements in the stored procedure show up in SQL Profiler, including the final SELECT statement I have the indicates a successful result. But, the data does not end up in the table and the ASP.net page returns an error.
Also, I have run both the Stored Proceure and the SQL insert statement making all of the fields blank as a way of ensuring that no value can be longer than a field's size. But, in both cases I still get the same error.
Here's the line I use when doing a regular insert:
Dim Command4 = New Data.SqlClient.SqlCommand("INSERT INTO ResourceCenter(UserEmail, UserPassword, Region, FirstName, LastName, Company, JobTitle, Address1, Address2, City, StateProvince, ZipPostalCode, Country, BusinessPhone, WebSiteURL, HowDidYouFind, Industry, WhatTypeOfSolution, CompanySize, NumLogins, LastLogin) VALUES ('" & UserEmail & "', '" & UserPassword & "', '" & Region & "', '" & FirstName & "', '" & LastName & "', '" & Company & "', '" & JobTitle & "', '" & Address1 & "', '" & Address2 & "', '" & City & "', '" & StateProvince & "', '" & ZipPostalCode & "', '" & Country & "', '" & BusinessPhone & "', '" & WebSiteURL & "', '" & HowDidYouFind & "', '" & Industry & "', '', '', 1, " & Now & ")", conn2)
Dim NumRowsUpdated2 = Command4.ExecuteNonQuery()
Here's my code when I call a stored procedure:
Dim dsSignup As New Data.DataSet()Dim Command4 As New Data.SqlClient.SqlDataAdapter("ap_ResourceCenterModify", conn2)Command4.SelectCommand.CommandType = Data.CommandType.StoredProcedureCommand4.SelectCommand.Parameters.Add("@UserID", Data.SqlDbType.Int, 0).Value = 0Command4.SelectCommand.Parameters.Add("@UserEmail", Data.SqlDbType.VarChar, 100).Value = UserEmailCommand4.SelectCommand.Parameters.Add("@UserPassword", Data.SqlDbType.VarChar, 20).Value = UserPasswordCommand4.SelectCommand.Parameters.Add("@Region", Data.SqlDbType.VarChar, 50).Value = RegionCommand4.SelectCommand.Parameters.Add("@FirstName", Data.SqlDbType.VarChar, 100).Value = FirstNameCommand4.SelectCommand.Parameters.Add("@LastName", Data.SqlDbType.VarChar, 100).Value = LastNameCommand4.SelectCommand.Parameters.Add("@Company", Data.SqlDbType.VarChar, 100).Value = CompanyCommand4.SelectCommand.Parameters.Add("@JobTitle", Data.SqlDbType.VarChar, 100).Value = JobTitleCommand4.SelectCommand.Parameters.Add("@Address1", Data.SqlDbType.VarChar, 100).Value = Address1Command4.SelectCommand.Parameters.Add("@Address2", Data.SqlDbType.VarChar, 100).Value = Address2Command4.SelectCommand.Parameters.Add("@City", Data.SqlDbType.VarChar, 100).Value = CityCommand4.SelectCommand.Parameters.Add("@StateProvince", Data.SqlDbType.VarChar, 50).Value = StateProvinceCommand4.SelectCommand.Parameters.Add("@ZipPostalCode", Data.SqlDbType.VarChar, 50).Value = ZipPostalCodeCommand4.SelectCommand.Parameters.Add("@Country", Data.SqlDbType.VarChar, 200).Value = CountryCommand4.SelectCommand.Parameters.Add("@BusinessPhone", Data.SqlDbType.VarChar, 100).Value = BusinessPhoneCommand4.SelectCommand.Parameters.Add("@WebSiteURL", Data.SqlDbType.VarChar, 200).Value = WebSiteURLCommand4.SelectCommand.Parameters.Add("@HowDidYouFind", Data.SqlDbType.VarChar, 100).Value = HowDidYouFindCommand4.SelectCommand.Parameters.Add("@Industry", Data.SqlDbType.VarChar, 100).Value = IndustryCommand4.SelectCommand.Parameters.Add("@WhatTypeOfSolution", Data.SqlDbType.VarChar, 250).Value = WhatTypeOfSolutionCommand4.SelectCommand.Parameters.Add("@CompanySize", Data.SqlDbType.VarChar, 100).Value = CompanySizeCommand4.Fill(dsSignup)Any ideas of what else I can try? Thanks in advance.
View 4 Replies
View Related
Jan 19, 2008
Hi,I am getting the following error:System.Data.SqlClient.SqlException: String or binary data would be
truncated.The statement has been terminated.Can someone tell me what it means?Thanks,Jon
View 2 Replies
View Related
Jan 7, 2004
I am trying to pass a multi lined text field into my SQL Server database. I tried varchar and set the length to 1000 but I still can only pass upto 50 charcters. I also have tried to use other data types like nvarchar, text, and ntext but the text and ntext won't allow me to chenge the length of the field and n varchar will only allow up to 50 charcters no matter how big I make the length. Any help you can give me would be great.
David
View 14 Replies
View Related
Jun 21, 2004
I have a stored proc that inserts binary data into an image field.
I am getting a "String or binary data would be truncated" error when trying to insert large data, but this is *no where* near the maximum size of the image datatype.
Should I be declaring the size of the image parameter in my SQLCommand or something?
TIA,
Mark
Code example:
The sproc:
ALTER PROCEDURE sproc_Content_Insert
(
@ContentName varchar(250),
@ContentDesc varchar(500),
@ContentType varchar(25),
@Content image,
@LocationID int
)
AS
INSERT INTO tbl_Content (ContentName, ContentDesc, ContentType, Content, LocationID)
VALUES (@ContentName, @ContentDesc, @ContentType, @Content, @LocationID)
The method:
Public Sub SaveBinaryContent(ByRef ContentName As String, ByRef ContentDesc As String, ByRef ContentType As String, ByRef Content As String, ByRef LocationID As Integer)
'convert the content to a binary stream.
Dim ms As New System.IO.MemoryStream
Dim bf As New BinaryFormatter
bf.Serialize(ms, Content)
ms.Position = 0
Dim oConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim cmd As New SqlCommand("sproc_Content_Insert", oConn)
With cmd
.CommandType = CommandType.StoredProcedure
.Parameters.Add("@ContentName", ContentName)
.Parameters.Add("@ContentDesc", ContentDesc)
.Parameters.Add("@ContentType", ContentType)
.Parameters.Add("@Content", ms.ToArray)
.Parameters.Add("@LocationID", LocationID)
End With
oConn.Open()
cmd.ExecuteNonQuery()
oConn.Close()
oConn.Dispose()
cmd.Dispose()
bf = Nothing
ms = Nothing
End Sub
View 1 Replies
View Related
May 2, 2005
Hi all,
when ever i try uploadin the file to the database, i am facing this weird probs :(
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.Source Error:
Line 124:
Line 125:// Update data source
Line 126:dbAdapt.Update(dbSet,"tblFile1");
Line 127:
Line 128:// Get newFileID
i donno what this means :(
well the code is like this
private void Button1_Click(object sender, System.EventArgs e)
{
HttpPostedFile myFile = filMyFile.PostedFile;
// Get size of uploaded file
nFileLen = myFile.ContentLength;
nFiletype = myFile.ContentType;
// Allocate a buffer for reading of the file
myData = new byte[nFileLen];
// Read uploaded file from the Stream
myFile.InputStream.Read(myData, 0, nFileLen);
strFilename = Path.GetFileName(myFile.FileName);
if( myData.Length != 0)
{
WriteToDB(strFilename,nFiletype,ref myData);
}
}
private int WriteToDB(string strName, string strType, ref byte[] Buffer)
{
int nFileID = 0;
// Create connection
SqlConnection dbConn = new SqlConnection("Data Source=D3BKIRAN; Database=ooc;UID=sa;Password=*****");
// Create Adapter
SqlDataAdapter dbAdapt = new SqlDataAdapter("SELECT * FROM tblFile1", dbConn);
// Create and initialize CommandBuilder
SqlCommandBuilder dbCB = new SqlCommandBuilder(dbAdapt);
// Open Connection
dbConn.Open();
// New DataSet
DataSet dbSet = new DataSet();
// Populate DataSet with data
dbAdapt.Fill(dbSet, "tblFile1");
// Get reference to our table
DataTable dbTable = dbSet.Tables["tblFile1"];
// Create new row
DataRow dbRow = dbTable.NewRow();
// Store data in the row
dbRow["FileName"] = strName;
dbRow["FileSize"] = Buffer.Length;
dbRow["ContentType"] = strType;
dbRow["FileData"] = Buffer;
// Add row back to table
dbTable.Rows.Add(dbRow);
// Update data source
dbAdapt.Update(dbSet,"tblFile1");
// Get newFileID
if( !dbRow.IsNull("FileID") )
nFileID = (int)dbRow["FileID"];
// Close connection
dbConn.Close();
// Return FileID
return nFileID;
}
plz any one give me an soln for the same
thanks in advance
View 5 Replies
View Related
