How can I change my Primary Key

Hello,
I have transactional replication in place with @. 450 articles in the main
publication.
I need to modify the primary key to include an additional field.
How can I do this best?
Thanks.
~Lb
you can't without dropping your subscriptions and publications.
"Lonnye Blake Bower" <lbower@.excellerx.com> wrote in message
news:OoJcCdAMFHA.1096@.tk2msftngp13.phx.gbl...
> Hello,
> I have transactional replication in place with @. 450 articles in the main
> publication.
> I need to modify the primary key to include an additional field.
> How can I do this best?
> Thanks.
> ~Lb
>
|||Thank you...
Can I remove the table from the publication easily and then make the
changes... and finally create a new publication with just this table?
|||yes with transactional replication you can do with by using sp_droparticle.
You will have to drop the subscription(s) before you do this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lonnye Blake Bower" <lbower@.excellerx.com> wrote in message
news:%23c3blpAMFHA.3632@.TK2MSFTNGP10.phx.gbl...
> Thank you...
> Can I remove the table from the publication easily and then make the
> changes... and finally create a new publication with just this table?
>
sql

How can I change database status from loading

When I started restore, I used leave non operational. But later I find out
that I do not need to apply any additional files. I want to make it
operational. I am using SQL 7.
Any idea how can I change this status ? Thank you very much for reply.Try running the following:
RESTORE DATABASE YourDatabaseName
WITH RECOVERY
If it does not work try the last log backup filename and location.
RESTORE DATABASE YourDatabaseName
FROM DISK = 'c:\bkup.bak'
WITH RECOVERY
I do not have SQL 7 around but it works on 2000
Hope it will do the trick
Andre
"Astros" wrote:

> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||In Query Analyzer, you can run
RESTORE [mydatabase] WITH RECOVERY
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||Forgot the word DATABASE...
RESTORE DATABASE [mydatabase] WITH RECOVERY
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eUafDry$EHA.600@.TK2MSFTNGP09.phx.gbl...
> In Query Analyzer, you can run
> RESTORE [mydatabase] WITH RECOVERY
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
>

How can I change database status from loading

When I started restore, I used leave non operational. But later I find out
that I do not need to apply any additional files. I want to make it
operational. I am using SQL 7.
Any idea how can I change this status ? Thank you very much for reply.
Try running the following:
RESTORE DATABASE YourDatabaseName
WITH RECOVERY
If it does not work try the last log backup filename and location.
RESTORE DATABASE YourDatabaseName
FROM DISK = 'c:\bkup.bak'
WITH RECOVERY
I do not have SQL 7 around but it works on 2000
Hope it will do the trick
Andre
"Astros" wrote:

> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.
|||In Query Analyzer, you can run
RESTORE [mydatabase] WITH RECOVERY
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.
|||Forgot the word DATABASE...
RESTORE DATABASE [mydatabase] WITH RECOVERY
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eUafDry$EHA.600@.TK2MSFTNGP09.phx.gbl...
> In Query Analyzer, you can run
> RESTORE [mydatabase] WITH RECOVERY
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
>

How can I change database status from loading

When I started restore, I used leave non operational. But later I find out
that I do not need to apply any additional files. I want to make it
operational. I am using SQL 7.
Any idea how can I change this status ? Thank you very much for reply.Try running the following:
RESTORE DATABASE YourDatabaseName
WITH RECOVERY
If it does not work try the last log backup filename and location.
RESTORE DATABASE YourDatabaseName
FROM DISK = 'c:\bkup.bak'
WITH RECOVERY
I do not have SQL 7 around but it works on 2000
Hope it will do the trick
Andre
"Astros" wrote:
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||In Query Analyzer, you can run
RESTORE [mydatabase] WITH RECOVERY
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||Forgot the word DATABASE...
RESTORE DATABASE [mydatabase] WITH RECOVERY
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eUafDry$EHA.600@.TK2MSFTNGP09.phx.gbl...
> In Query Analyzer, you can run
> RESTORE [mydatabase] WITH RECOVERY
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
>> When I started restore, I used leave non operational. But later I find
>> out
>> that I do not need to apply any additional files. I want to make it
>> operational. I am using SQL 7.
>> Any idea how can I change this status ? Thank you very much for reply.
>