Re: Problem altering table and adding a default

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: J.Marsch (jeremy_at_ctcdeveloper.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 09:27:49 -0600

Billy:

There is one mystery left for me. The issue is that I want to use
Enterprise Manager to create a new column. This column should not accept
nulls. I want to assign a user defined default to the column. In
Enterprise Manager, I get an error trying to perform this action. However,
buth Kalen and I have performed this action in the past with no error. That
leads me to believe that there is either a bug or some kind of configuration
discrepancy in Enterprise Manager. I would love to be able to confirm this.

-- Jeremy

""Billy Yao [MSFT]"" <v-binyao@online.microsoft.com> wrote in message
news:vNFcMto9DHA.704@cpmsftngxa07.phx.gbl...
> Hi Jeremy,
>
> I would like to follow up on this issue and see if we have answered your
question. I haven't
> heard from you in 2 days, were you able to check Kalen's reply? Should you
have any
> questions, please feel free to post here.
>
> Based on my understanding on this issue, I believe User Defined Default
can not be
> referenced in ALTER TABLE or CREATE TABLE statement. We can use
sp_bindefault to
> bind it to a column or to a user-defined data type, instead of using
Enterprise Manager GUI
> tool.
>
> Thanks for posting in the community.
>
> Best regards,
>
> Billy Yao
> Microsoft Online Support
> ----------------------------------------------------
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>
>
>
>
>