SQL error Microsoft SQL Server reported SQL message 8152, seve

SQL error Microsoft SQL Server reported SQL message 8152, seve

Post by dGVsZWtvbS » Thu, 26 Jan 2006 17:04:03


Thank you, youe been most helpful.

--
System Administrator
Telecom Serbia
 
 
 

SQL error Microsoft SQL Server reported SQL message 8152, seve

Post by leelil » Thu, 26 Jan 2006 18:28:29

Hi,

I am glad to be of assistance.
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.

 
 
 

SQL error Microsoft SQL Server reported SQL message 8152, seve

Post by d29ybGR3aW » Fri, 28 Apr 2006 00:02:02

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 ...
 
 
 

SQL error Microsoft SQL Server reported SQL message 8152, seve

Post by GianlucaDe » Sat, 13 May 2006 22:01:01

Hi to all,
same problem for my SMS Server.
Many Thanks for your help, I have expand to 128 varchar and all it's ok
now.

Why there isn't a KB in www.microsoft.com to resolve this problem ?

Many thanks
Regards
Gianluca