Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 2,897 total)

  • RE: script to find tables in the database without PK or indexes

    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...

  • RE: script to find tables in the database without PK or indexes

    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...

  • RE: SQL Mail and Replication

    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...

  • RE: SQL Mail and Replication

    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 ?

  • RE: Initializing replication

    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 &...

  • RE: Initializing replication

    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...

  • RE: SQL Mail and Replication

    I saw it already, but didn't have any ideas about it.

  • RE: SQL Mail and Replication

    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...

  • RE: SQL Mail and Replication

    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...

  • RE: Replicate Table

    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 Updating

    Immediate...

  • RE: Replication vs Transation Logshipping

    " ... 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" -...

  • RE: DTS package giving problem

    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...

  • RE: tables with vertical partition

    They're all in the same publication ??      I dunno

  • RE: Vertical partition for an article

    Didn't you just post this in the Replication forum (where it belongs).  As the saying goes "Please don't cross post"

  • RE: SP4 vs SP3 ??

    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...

Viewing 15 posts - 2,641 through 2,655 (of 2,897 total)