Viewing 15 posts - 2,671 through 2,685 (of 2,900 total)
If I understand you correctly, than these comments come to mind:
" ... Recreates snapshot daily at 4 am. ..."
If you're doing transactional replication, you only need to run the snapshot...
October 5, 2005 at 3:02 pm
I did this with good results when I needed to change the length of a field in a replicated table. -- Specifically: Drop a table from a publication so...
October 4, 2005 at 9:37 am
Good points. I found this article about default DB, and the follow-up discussion at: http://www.sqlservercentral.com/columnists/awarren/settingadefaultdatabaseforyourlogins.asp
The consensus seemed to be to either use tempdb as the default, or set up...
October 4, 2005 at 8:36 am
Why Pubs instead of Master ?? Because Master is too dangerous to mess with ?
October 3, 2005 at 11:10 am
Some more detail perhaps ? This occurs while creating the publication or subscription ? At what point in the process ?? What type of replication ?
October 3, 2005 at 9:54 am
I think that was it ... Thanks !. I set all the group logins to Master & things are back to normal.
October 3, 2005 at 8:07 am
You have to check the Advanced Options box in the create Publication wizard in order to get the option to enable subscriber updates, otherwise the default is no updating. I...
September 29, 2005 at 11:02 pm
What sort of results are you looking for ? You want to update the table to look something like this ?
September 29, 2005 at 2:45 pm I'm really sorry about the multiple posts. I was getting the memory errors on the site just as I was trying to post, and it seems to have put miltiple... September 29, 2005 at 2:30 pm I think you could say that Reinitialization is "flagging" the subscription to get the next snapshot, provided that a new snap shot is run, then the agent is run. If the... September 29, 2005 at 1:54 pm Wouldn't transactional replication WITHOUT immediate updating subscribers work ? Then you'll just be replicating from A to B only. September 29, 2005 at 12:47 pm FYI ... You might want to re-post this under a SQL Mail title for better feedback. September 29, 2005 at 8:18 am I've had SQL mail working with Notes .... and I've also had it stop working for no apparent reason. Currently I'm bypassing Notes and bouncing of a different server. We're... September 28, 2005 at 3:27 pm SQL Mail ? uugghh ........ that's a whole separate issue ... SP4 won't help September 28, 2005 at 2:41 pm Enterprise Manager, right click the server -->> Properties then look at the "Product version" Or run @@version, but that displays the actual build #, which is a little less clear (eg 8.00.2039... September 28, 2005 at 2:03 pm Viewing 15 posts - 2,671 through 2,685 (of 2,900 total) |