Re: Change Unique ID to non unique ID in replicated table
From: Vivek Sharma (joebloggs_at_news.com)
Date: 09/01/04
- Next message: Vivek Sharma: "Stopping agents to start when server is rebooted"
- Previous message: Mario Michela: "Re: Replication between 2 SBS (small business server) Trusts"
- In reply to: Hilary Cotter: "Re: Change Unique ID to non unique ID in replicated table"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 09:57:33 +1200
Thanks a lot Hilary. It was a great help.
Vivek
"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:elqZKECkEHA.384@TK2MSFTNGP10.phx.gbl...
> You will have to alter the table to drop the constraint
>
> create table primarykey
> (pk int not null identity(1,1) primary key)
> GO
> sp_help primarykey
> GO
> --scroll down until you see the name of the primary key - in our case its
> called PK__primarykey__52AE4273
> alter table primarykey
> drop constraint PK__primarykey__52AE4273
> GO
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
>
> "Vivek Sharma" <joebloggs@news.com> wrote in message
> news:OV7xLN9jEHA.2412@TK2MSFTNGP15.phx.gbl...
> > Hi Hillary,
> >
> > Thanks for your reply. I think I should have framed my query
differently.
> > I have a table on publisher with a primary key. What we intend to do is
> get
> > rid of the primary key so that we can insert any number and the
following
> > records. Now, how do I can I change the column to be not primary key.
> >
> > Thanks
> >
> > Vivek
> >
> >
> > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> > news:%23Dv3VS1jEHA.1520@TK2MSFTNGP10.phx.gbl...
> > > Exactly what do you mean by non-unique. There are three kinds of
> indexes,
> > > clustered, non clustered or unique.
> > >
> > > Unique means an index or actually a constraint that uses an index,
which
> > > ensures unique values and allows a null. A non-clustered index is an
> index
> > > that is maintained on a seperate database page containing pointers
which
> > > point back to where in the table a particular value occurs. A
clustered
> > > index orders the data in the table according to a criteria.
> > >
> > > To change an index you do this
> > >
> > > sp_help tablename and obtain the index name
> > >
> > > then drop the index
> > >
> > > drop index authors.aunmind
> > >
> > > then recreate it (if you want to convert the index to a clustered or
> > > non-clustered index).
> > >
> > > I assume you are talking about the table on the subscriber.
> > >
> > > If you want to replicate a primary key which occurs on a published
table
> > on
> > > the publisher to a primary key on the subscriber right click on yoru
> > > publication, select properties, click the articles tab, and click the
> > three
> > > ellipses next to your article you wish to modify the index on. Then in
> the
> > > snapshot tab, check include DRI. By default primary keys are
replicated
> as
> > > unique indexes on the subscriber.
> > >
> > > HTH
> > >
> > > --
> > > Hilary Cotter
> > > Looking for a book on SQL Server replication?
> > > http://www.nwsu.com/0974973602.html
> > >
> > >
> > > "Vivek" <vivek@nospam.com> wrote in message
> > > news:uMeeotwjEHA.2908@TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > >
> > > > I have a replicated to table. It has the ID column as unique and I
> want
> > > it
> > > > to convert it into non unique. How can I do it?
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Vivek Sharma: "Stopping agents to start when server is rebooted"
- Previous message: Mario Michela: "Re: Replication between 2 SBS (small business server) Trusts"
- In reply to: Hilary Cotter: "Re: Change Unique ID to non unique ID in replicated table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
