Re: Changing Default Names
From: Dave (anonymous_at_discussions.microsoft.com)
Date: 04/02/04
- Next message: Vitali: "event and its associated handler for automating predefined actions"
- Previous message: Chuck: "Excesive Space Allocated"
- In reply to: Kalen Delaney: "Re: Changing Default Names"
- Next in thread: Kalen Delaney: "Re: Changing Default Names"
- Reply: Kalen Delaney: "Re: Changing Default Names"
- Reply: Kalen Delaney: "Re: Changing Default Names"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Apr 2004 05:29:58 -0800
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.
>> >> > >
>> >> > >
>> >> > >.
>> >> > >
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Vitali: "event and its associated handler for automating predefined actions"
- Previous message: Chuck: "Excesive Space Allocated"
- In reply to: Kalen Delaney: "Re: Changing Default Names"
- Next in thread: Kalen Delaney: "Re: Changing Default Names"
- Reply: Kalen Delaney: "Re: Changing Default Names"
- Reply: Kalen Delaney: "Re: Changing Default Names"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
