Context:  SQL Server 2000 Personal Edition on Windows 2000 Pro.
              I designed a table using the design view and forms.
              No data added.
              Checked "Check existing data on creation"
              Generated script with extended properties
              Script created without a problem in Query Analyzer
              Script error when scripting in Enterprise Mgr

Problem: The generated script text file contains all selected settings
              except the "Check existing data on creation"

Question: Two questions:
              1. Why do I get the fil error using EM?
              2. Why is script not generated for the cited checkboc

Sparky

add column
ntext and update/insert triggers
Error converting data type nvarchar to int.
move records from table1 to table2 if does not exist in table3
Multiple instances of MSSQL and IP addresses