Need to add a table in merge replication

Hi,
I would like to add a new table in merge replication (200 tables already in
replication).
I followed the steps.
Step 1: In publication properties I included the new table
Step 2: System shows the following messages
One or more tables have already been published. Do you want to update those
articles with the new default?
I gave ‘NO’
Step 3: When I click Apply it shows the following message.
SQL Server Enterprise Manager could not change the properties of article
‘Table name’
Based on object ‘Table name’.
Do you want to continue saving other changes to the publication?
Error 21416: Property ‘destination_owner’ of article ‘Table Name’ cannot be
changed.
Since I have 200 tables in merge replication it asks for 200 times and I
have ‘Yes’ and finally it shows the following error message.
SQL Server Enterprise Manager could not create article ‘NewTablename’ on
object ‘NewTablename’.
Do you want to continue saving other changes to the publication?
Error 20086: Publication ‘DatabaseName’ does not support the nosync type
because it contains a table that does not have a rowguidcol column.
Finally,
I created a new column ‘rowguid’ after that followed the same steps.
Its working fine.
Need clarification:
1.Should I create a similar table in subscriber also? (else it replication
fails)
2.Am I going in a correct way?
Please advise
Thanks,
Soura.
Sometimes the GUI is not your friend. This is one of these cases. I think
what is going on is that this new table is related via DRI to some of the
other tables and the tracking metadata has to be updated. This means a new
snapshot; but for some reason - possibly a bug you are unable to do this
through the GUI.
Your options won't work. Basically you are creating two tables which are
configured somewhat correctly (but not completely) for merge replication,
but are missing the necessary merge replication metadata in the system
tables
What I would do is create a seperate publication. This could be problematic
if you have a lot of subscribers.
Another option which probably is the way to go is to use sp_addmergearticle
like this
sp_addmergearticle 'northwind2','authors','authors',
@.force_invalidate_snapshot=1
This will generate a mini snapshot with just the authors table in it.
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
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:825361FD-DF36-4D78-9E79-6938A34A9CE2@.microsoft.com...
> Hi,
> I would like to add a new table in merge replication (200 tables already
in
> replication).
> I followed the steps.
> Step 1: In publication properties I included the new table
> Step 2: System shows the following messages
> One or more tables have already been published. Do you want to update
those
> articles with the new default?
> I gave 'NO'
> Step 3: When I click Apply it shows the following message.
> SQL Server Enterprise Manager could not change the properties of article
> 'Table name'
> Based on object 'Table name'.
> Do you want to continue saving other changes to the publication?
> Error 21416: Property 'destination_owner' of article 'Table Name' cannot
be
> changed.
> Since I have 200 tables in merge replication it asks for 200 times and I
> have 'Yes' and finally it shows the following error message.
> SQL Server Enterprise Manager could not create article 'NewTablename' on
> object 'NewTablename'.
> Do you want to continue saving other changes to the publication?
> Error 20086: Publication 'DatabaseName' does not support the nosync type
> because it contains a table that does not have a rowguidcol column.
> Finally,
> I created a new column 'rowguid' after that followed the same steps.
> Its working fine.
> Need clarification:
> 1. Should I create a similar table in subscriber also? (else it
replication
> fails)
> 2. Am I going in a correct way?
> Please advise
> Thanks,
> Soura.
>
|||Actually it seems to generate a completely new snapshot.
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
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:825361FD-DF36-4D78-9E79-6938A34A9CE2@.microsoft.com...
> Hi,
> I would like to add a new table in merge replication (200 tables already
in
> replication).
> I followed the steps.
> Step 1: In publication properties I included the new table
> Step 2: System shows the following messages
> One or more tables have already been published. Do you want to update
those
> articles with the new default?
> I gave 'NO'
> Step 3: When I click Apply it shows the following message.
> SQL Server Enterprise Manager could not change the properties of article
> 'Table name'
> Based on object 'Table name'.
> Do you want to continue saving other changes to the publication?
> Error 21416: Property 'destination_owner' of article 'Table Name' cannot
be
> changed.
> Since I have 200 tables in merge replication it asks for 200 times and I
> have 'Yes' and finally it shows the following error message.
> SQL Server Enterprise Manager could not create article 'NewTablename' on
> object 'NewTablename'.
> Do you want to continue saving other changes to the publication?
> Error 20086: Publication 'DatabaseName' does not support the nosync type
> because it contains a table that does not have a rowguidcol column.
> Finally,
> I created a new column 'rowguid' after that followed the same steps.
> Its working fine.
> Need clarification:
> 1. Should I create a similar table in subscriber also? (else it
replication
> fails)
> 2. Am I going in a correct way?
> Please advise
> Thanks,
> Soura.
>
sql

Need Steps to upgrade SQL Yukon 9.00.852 (Intel X86) to 9.00.1399.06

Hi SQL DBA,s

What are the step to upgrade ?

Microsoft SQL Server Yukon - 9.00.852 (Intel X86) version To
Sql 2005 Standard {9.00.1399.06}.

When I tries to backup and restore from this 9.00.852 version to Sql 2005 Standard {9.00.1399.06}.
It is giving me an error that this version is not compatible.

What we need to do know ?

Also let me know where I can download SQL Server Yukon - 9.00.852 (Intel X86) version so I can do the test on test box.

Thanks In advance.

You can try exporting and importing the data to a .sql file.sql

need steps to modify the CSS for viewer/ toolbar

I want to use the CSS stylesheet to modify the viewer/ toolbar.
This may be a dumb question, but can anyone please tell me:
What are the steps to modify the CSS?
Also - please tell me what kind of things I can do with it?
I have been trying to open the CSS in a text editor and playing with
it, with limited success and limited vision of what can be done.
ThanksHere is a little more specific question:
All the properties regarding parameters I see in the CSS are as below.
I want to change the font size of the parameter prompt, and I would
like to put 3 in a row instead of 2. Is that possible?
Actually - I would like to some more... but even if the above is
possible, it would be helpful. Thx
.ParametersFrame
{
border-bottom: 1px darkgray solid
}
.ParamLabelCell
{
padding: 10px;
padding-right: 5px;
vertical-align: baseline
}
.ParamEntryCell
{
padding: 1px;
vertical-align: baseline
}
.ParamsGrid
{
margin: 0px;
padding: 1px
}
.InterParamPadding
{
padding-left: 1px
}|||hey,
ok, sorry to hijack your question, but I am wondering about the same
thing. Something else I'd like to do is add to the toolbar if
possible. For a parameter textfield for a date say, I'd like to place
a calandar control if possible...
Anyone know if it's possible to get at the code for the control
somewhere and hack at it there to make personalised changes?
Also, something else that might sound silly but - even as the report
is being generated there is an animated gif. Anyone know how to
change that?
Thanks...
creative@.mailcity.com (Harsh) wrote in message news:<fa671a26.0408282005.4829c524@.posting.google.com>...
> Here is a little more specific question:
> All the properties regarding parameters I see in the CSS are as below.
> I want to change the font size of the parameter prompt, and I would
> like to put 3 in a row instead of 2. Is that possible?
> Actually - I would like to some more... but even if the above is
> possible, it would be helpful. Thx
>
> .ParametersFrame
> {
> border-bottom: 1px darkgray solid
> }
> .ParamLabelCell
> {
> padding: 10px;
> padding-right: 5px;
> vertical-align: baseline
> }
> .ParamEntryCell
> {
> padding: 1px;
> vertical-align: baseline
> }
> .ParamsGrid
> {
> margin: 0px;
> padding: 1px
> }
> .InterParamPadding
> {
> padding-left: 1px
> }|||Still no answers... neither to my question nor to yours.
Maybe there is no way of hacking into the "parameter viewer" but can
anyone please explain what are the things I CAN achieve... with the
current functionality?
I have tried reading the SP1 readme but that does not seem to say
anything.
I want to know this before I decide on building my own viewer.
Thanks