Post reply

Renaming Defaults in SQL Server 2000

  • August 2, 2002 at 6:56 am

    #79163

    When renaming defaults in SQL Server 2000, why doesn't it update the create script? Is this a documented bug? Will there be a SP for it?

  • August 2, 2002 at 8:17 am

    #433900

    I just did the script and recreated the bug. An excerpt of what I'm seeing:

    

    if exists (select 

                   * 

               from dbo.sysobjects 

               where id = object_id(N'[dbo].[ANewTestDefault]') 

                 and OBJECTPROPERTY(id, N'IsDefault') = 1)

    drop default [dbo].[ANewTestDefault]

    GO

    

    create default [ATestDefault] as 0

    GO

    Looks like a bug. Have you contacted Microsoft about it?

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    Edited by - bkelley on 08/02/2002 08:18:10 AM

    K. Brian Kelley
    @kbriankelley

  • August 2, 2002 at 8:31 am

    #433902

    No, I have not contacted Microsoft about it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply