Viewing 15 posts - 376 through 390 (of 1,790 total)
michael.morse (1/31/2011)
This website is great for finding the help you need when you are stuck. Thank you for you help.
Completely agree. I know I look here before anywhere else...
January 31, 2011 at 11:55 am
Great. Let me know how this works.
January 31, 2011 at 11:31 am
michael.morse (1/31/2011)
When I do a manual sync of the data I am using import/export wizard to do this is this ok or should I be doing it a different way?
That...
January 31, 2011 at 10:34 am
Have you added the subscriptions yet? When you do that do not initialize them though.
January 31, 2011 at 10:33 am
michael.morse (1/31/2011)
Oh in response to your question I mean edit the field order in the stored procedures. I know where to edit the names.
Ok, you shouldn't have to alter...
January 31, 2011 at 10:18 am
Ok, so don't initialize when creating the subscription. The procedures should be fine as long as you remember to name them distinctly in the publications on each publisher.
To get...
January 31, 2011 at 10:16 am
michael.morse (1/31/2011)
Its seems the data must be initialized first in order to get the stored procedures copied to the subscription database. Where can I edit them before this?
The procedures...
January 31, 2011 at 10:10 am
Sorry, yes the initial data you would want to initialize.
Glad you have the test environment. I'll breathe now. 😛
January 28, 2011 at 3:41 pm
One final note, being that your subscriber is actually your complete data set you want to make sure that you do NOT initialize any of these publications or they will...
January 28, 2011 at 3:36 pm
michael.morse (1/28/2011)
January 28, 2011 at 3:33 pm
Ok, that makes sense. So then back to my earlier question, do you not see the option to change how the commands are replicated in the publication / article properties?...
January 28, 2011 at 3:22 pm
michael.morse (1/28/2011)
Can you modify records in a view which in turn would update the tables?
I guess I'm a bit confused. Are you planning on updating the table on the subscriber?...
January 28, 2011 at 3:16 pm
Right - but the application would only be pointed to the view. The application wouldn't have to care about the underlying tables.
Let me know if I am not understanding...
January 28, 2011 at 3:03 pm
Not certain. Sorry - I don't have a 2000 server to look at either. Are you not seeing those options?
I am curious though why the option that GSquared offered...
January 28, 2011 at 2:32 pm
Right click on the publication, Properties, select the table in question, on the right hand side select "Article Properties" drop down and select "Set properties of highlighted table article". Scroll...
January 28, 2011 at 2:08 pm
Viewing 15 posts - 376 through 390 (of 1,790 total)