SQL error Microsoft SQL Server reported SQL message 8152, severity

SQL error Microsoft SQL Server reported SQL message 8152, severity

Post by dGVsZWtvbS » Wed, 25 Jan 2006 18:28:02


When I checked ddm.log there is this line:
CDiscoverySource_SQL::UpdateItem - could not execute sql- insert into
System_SMS_Assign_ARR (ItemKey, SMS_Assigned_Sites0) values (12452, "SMS:NK1")

And when I checked System_SMS_Assign_ARR table, columns in it are like this:
ColumnName DataType Lenght
ItemKey int 4
SMS_Assigned_Sites0 varchar 4

I suppose that I need to change length, but I would like to hear from
somebody who knows more than me about this.

thanks


--
System Administrator
Telecom Serbia
 
 
 

SQL error Microsoft SQL Server reported SQL message 8152, severity

Post by leelil » Thu, 26 Jan 2006 11:33:39

Hi,

Thank you for posting.

Yes the length of the "SMS_Assigned_Sites0" is incorrect in the SQL.
The SMS_Assigned_Sites0 should be a varchar with lenght of 128.
If it is 4 you will get the binary truncated warning message.
Please correct the length in the DB.

Have a nice day!

Sincerely,

Lee Li
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://www.yqcomputer.com/ %2finternational.aspx.

=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.