RE: SQL error Microsoft SQL Server reported SQL message 8152, seve

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi @all!

I also got the same problem on one of our sms servers.
But when I want to edit the SQL table properties I get a warning message
that says:

'System_SMS_Assign_ARR' table
- Warning: One or more existing columns have ANSI_PADDING 'off' and will be
re-created with ANSI_PADDING 'on'.
- Warning: The table was created with ANSI_NULLS 'off' and will be
re-created with ANSI_NULLS 'on'.

Is this ok? (I'm not very firm with SQL 2000!)

I also had a look on a newly installed sms site server about the lenght of
the 'SMS_Assigned_Site0' value, but there it had a lenght of 64!

Please answer ...

--
worldwidewilli


""Lee Li[MSFT]"" wrote:

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://support.microsoft.com/default.aspx?scid=%2finternational.aspx.

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


.

Relevant Pages

  • Re: Inserted images appear in text
    ... Microsoft Product Support Services at 1-866-PCSAFETY. ... Searched the Registry for "Inline Images", found "Display Inline Images" at HKCU\Soft\MS\IE\Main and another in HKLM. ... The OE warning message was there but did not respond to a double clik so I temporarily unchecked "Do not allow attachments to be saved or opened..." ... Attachment window appeared allowing me to save the image. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • RE: Disable Compiler Waring
    ... order to disable some warning message in the project level, ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.vc.language)
  • Re: fgetcsv function paramters
    ... "," (comma) in the text somewhere. ... and the sql inserts stop at that point and doesn't finish inserting ... OH sorry, it was a long day, I forgot the f on fgetcsv() so I did it ... I got a warning message on ...
    (comp.lang.php)
  • Re: Any other tools around that tell me the firmware of my Seagate HDD?
    ... these boards would support IDE by default, ... attached to the second controller. ... Now I made another attempt in downloading SeaTools for Windows: ... I notice that there is a warning message to the effect that ...
    (comp.sys.ibm.pc.hardware.storage)
  • table delete warning
    ... when a user (system admin of SQL or an authorized used) want to delete a ... table in SQL, does SQL gives a warning message such that "Are you sure? ... are deleting a table" or it never gives a warning message? ...
    (microsoft.public.sqlserver.security)