Re: Changing Default Names

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 08:23:32 -0800

Can you try running the script that Adam provided, exactly as he specified
it and tell us what happens?

Thanks 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Dave" <anonymous@discussions.microsoft.com> wrote in message
news:1768501c418b6$97e79e70$a401280a@phx.gbl...
> I am connecting as sysadmin.
>
>
>
> >-----Original Message-----
> >Hi Dave
> >
> >Is it possible the constraint has a different owner than
> the user you are
> >currently connected as?
> >
> >--
> >HTH
> >----------------
> >Kalen Delaney
> >SQL Server MVP
> >www.SolidQualityLearning.com
> >
> >
> >"Dave" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:1725d01c41833$5dffcb20$a401280a@phx.gbl...
> >> NO. Here is what I am running:
> >>
> >>
> sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
> >> i_df', 'object'
> >>
> >>
> >> Here is what I get:
> >>
> >> Server: Msg 15248, Level 11, State 1, Procedure
> sp_rename,
> >> Line 223
> >> Either the parameter @objname is ambiguous or the
> claimed
> >> @objtype (object) is wrong.
> >>
> >>
> >>
> >> >-----Original Message-----
> >> >sorry, that was a CHECK constraint... here's a default:
> >> >
> >> >
> >> >create table a(id int)
> >> >GO
> >> >
> >> >create table b (id int)
> >> >GO
> >> >
> >> >alter table b add constraint r_b default (1) for id
> >> >GO
> >> >
> >> >sp_rename 'r_b', 'r_c', 'object'
> >> >GO
> >> >
> >> >"Adam Machanic" <amachanic@air-
> >> worldwide.nospamallowed.com> wrote in message
> >> >news:#oIt9BDGEHA.4044@TK2MSFTNGP10.phx.gbl...
> >> >> It works for me... Does the following work for you:
> >> >>
> >> >>
> >> >> create table a(id int)
> >> >> GO
> >> >>
> >> >> create table b (id int)
> >> >> GO
> >> >>
> >> >> alter table b add constraint r_b check (id = 1)
> >> >> GO
> >> >>
> >> >> sp_rename 'r_b', 'r_c', 'object'
> >> >> GO
> >> >>
> >> >> "Dave" <anonymous@discussions.microsoft.com> wrote in
> >> message
> >> >> news:1722a01c4182f$5d987aa0$a401280a@phx.gbl...
> >> >> > I can not use sp_rename because the defaults are
> not
> >> >> > recognized as objects.
> >> >> >
> >> >> >
> >> >> > >-----Original Message-----
> >> >> > >Hard to say if there are side effects; it's not
> the
> >> >> > supported way of
> >> >> > >renaming objects.  Instead, use sp_rename.  Look
> up
> >> >> > syntax in BOL.
> >> >> > >
> >> >> > >
> >> >> > >"Dave" <anonymous@discussions.microsoft.com>
> wrote in
> >> >> > message
> >> >> > >news:1444801c4182b$45f41160$a601280a@phx.gbl...
> >> >> > >> I am planning to change the default names from
> >> >> > >>
> >> >> > >> 'DF__tablename__columnname_28F7FFC9'to
> >> >> > >> 'tablename_columnname_df'.
> >> >> > >>
> >> >> > >> Depending on the number of default columns 'df1,
> >> df2,
> >> >> > >> df3 .....e.t.c' will be added.
> >> >> > >>
> >> >> > >> I am going to rename them in the 'sysobjects'
> table
> >> >> > where
> >> >> > >> I see the only location for them.
> >> >> > >>
> >> >> > >> Is there any side effects to this ?.
> >> >> > >>
> >> >> > >> Thanks for any help.
> >> >> > >
> >> >> > >
> >> >> > >.
> >> >> > >
> >> >>
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: Changing Default Names
    ... I am connecting as sysadmin. ... >Is it possible the constraint has a different owner than ... >Kalen Delaney ... >SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: convert a date to a string?
    ... Kalen Delaney ... SQL Server MVP ... > Declare @m int ...
    (microsoft.public.sqlserver.programming)
  • Re: Subquerie in CHECK Constrain
    ... I recall once retrieving a record set in VB, looping it and for each row, executing another ... Tibor Karaszi, SQL Server MVP ... >> Kalen Delaney ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: sa not starting in master-db
    ... that you were connecting using standard SQL security with the sa login. ... "jobi" wrote in message ... >> Is the sa database context set incorrectly when connecting from any ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: problem with query moving data from 1 dbase to another.
    ... Tibor Karaszi, SQL Server MVP ... "Paul" wrote in message ... > Syntax error converting the nvarchar to int. ... > Data_Item_Log_ID is type integer and the source field> (from another dbase on the same server) is type nvarchar 4. ...
    (microsoft.public.sqlserver.server)