Viewing 15 posts - 2,641 through 2,655 (of 2,897 total)
I was wondering what those "_WA_Sys_%" ones were all about. I omitted them, but didn't know if that was a reliable thing to do for accurate, long term results.
I still...
October 19, 2005 at 3:02 pm
I thought something like this would work:
select * from sysobjects a
where (not exists
(select * from sysindexes b where a.id = b.id))
and xtype = 'U'
order by name
But I find that...
October 19, 2005 at 1:47 pm
Have you read this ?
http://support.microsoft.com/default.aspx?scid=kb;en-us;321822
I had a problem a while back caused by the publisher being registered with the local name, not the actual server name.
When setting up...
October 18, 2005 at 9:41 am
Hmmmm that's odd ...... Do you see the server, but not the publications ?? Or do you not even see the server ? Are they on the same domain ?
October 18, 2005 at 8:26 am
I've only used Trans & Snapshot ... so I can't be much help with Merge. Since you're using Merge, I assume you have updates that occur at the publisher &...
October 14, 2005 at 2:45 pm
Are you setting up merge replication just to get the databases to be the same ? Backup & restore sounds the simplest solution to me.
After they are the same, then...
October 14, 2005 at 9:58 am
I saw it already, but didn't have any ideas about it.
October 14, 2005 at 9:52 am
After you're finished configuring replication, SQL will create a regular SQL Agent job. You can then edit that job just like any other job to add an additional step.
A...
October 14, 2005 at 8:10 am
Perhaps you can put a second step into your push subscription job. If the replication at step one fails, then your new step 2 won't happen. Step 2 writes a...
October 14, 2005 at 7:15 am
Changes at the subscriber CAN update the publisher if you've enabled "Immediate Updating". I haven't used it, but the option is there. Here's the first bit from BOL:
Immediate...
October 13, 2005 at 11:05 am
" ... When you say ""contimuosly updating" subscriber" do you mean a combination ..."
Replication creates the SQL Agent jobs. When you create the subscription, you can choose:
"Continuosly updating" -...
October 11, 2005 at 1:35 pm
I usually have the SQL Agent job create a log text file... It's often quite helpful in troubleshooting.
Job -> Steps -> Edit -> Advanced then specify a name & path...
October 11, 2005 at 12:16 pm
They're all in the same publication ?? I dunno
October 11, 2005 at 10:30 am
Didn't you just post this in the Replication forum (where it belongs). As the saying goes "Please don't cross post"
October 11, 2005 at 10:01 am
I've installed SP4 on 2 servers, and left SP3a on 2 other servers. I haven't had to do anything at the client, nor have I had any other problems or...
October 11, 2005 at 9:56 am
Viewing 15 posts - 2,641 through 2,655 (of 2,897 total)