Microsoft KB Archive/136109

{|
 * width="100%"|

BUG: Part of Defined Check Constraint May Not Be Visible in SEM

 * }

Q136109

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SYMPTOMS
You can enter a Check Constraint in SQL Enterprise Manager (SEM) New or Edit Table in Advanced Features which exceeds 63 characters. The edit control allows the entry of  (a carriage return) in the body of the text so that the actual definition can span multiple lines. When you subsequently view this Check Constraint in SQL Enterprise Manager Edit Table - Advanced Features, the Check Constraint is displayed as a single line and, depending on the length of the string, part of the Check Constraint may not be visible.

CAUSE
The current edit control used to display the Check Constraint does not support scrolling or word wrap.

WORKAROUND
The Check Constraint definition can be viewed in its entirety by using the stored procedure sp_helpconstraint, which is documented in the Microsoft SQL Server version 6.0 Online Help under "Transact-SQL Reference," or in the Transact-SQL Reference manual.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: sql6 SEM Check Edit

Keywords : kbusage

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600