• I got solution......... :-D:-D

    ALTER Table Owners

    ADD CONSTRAINT con_owname DEFAULT 'XXX' FOR owname

    But Y dont we use Default in the Alter statement. Event the below link shows it in Syntax...by SET Default...

    http://msdn.microsoft.com/en-us/library/ms174123.aspx