Here is url: http://msdn2.microsoft.com/en-US/library/aa237859(sql.80).aspx
Maya "Bruce, Rodney S Mr CTR USA AMC" <[EMAIL PROTECTED]> wrote: Yes, That worked Were did you find the syntex? I always seem to find: ALTER [COLUMN] column_name SET default_expr alters the default value for the column. As examples Thanks Rodney -----Original Message----- From: Maya Tulchinsky [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 04, 2007 10:22 AM To: SQL Subject: RE: Alter column problem ALTER TABLE Contact_tbl add default 'dddddd' for FirstName Tested and it should work if you currently don't have any defaults for this column. Maya "Bruce, Rodney S Mr CTR USA AMC" wrote: Thanks for suggection, but it didn't work either. Removing COLUMN changed the error message to: Msg 170, Level 15, State 1, Procedure SPTemp, Line 8 Incorrect syntax near the keyword 'FirstName '. The ";" doesn't seem to make a difference either way. Thanks Rodney -----Original Message----- From: Maya Tulchinsky [mailto:[EMAIL PROTECTED] Sent: Sunday, September 02, 2007 4:57 PM To: SQL Subject: Re: Alter column problem Try this: ALTER TABLE [dbo].[Contact_tbl] ALTER FirstName SET DEFAULT 'dddddd'; Hope this helps, Maya ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2942 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
