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

• 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 <cr> (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 SSrvAdmin SSrvEntMan kbbug6.00
Version : winnt:6.0
Platform : winnt
Issue type :