Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Idaho

    Them Boys in the Back Streets are good- we hear them singin' about potato-pickin' all the day long.

    As one who has worked as a SQL Server DBA in Idaho for...

    Jason

  • RE: Replication Issue

    I believe linked servers are required for replication.  How are your linked servers set up between publisher(s) and subscriber(s)?

    Jason

  • RE: TCP/IP not listening on the default port

    Is your install named?  ([servername]\instancename)?  If so- it would not, by default, listen on port 1433.  The listening port would dynamically assign a port on first start, or if the...

    Jason

  • RE: PK violation in replication

    If your PK is an IDENTITY, make sure it is 'NOT FOR REPLICTION'.  Also, for transactional replication verify that the subscriber is not being updated or inserted to.

    HTH

    Jason

    Jason

  • RE: More than one instance on a server?

    You need to have specific reasons to go multiple instance- because it does increase complexity and license costs if you are running Standard Edition.  Not to mention some applications have...

    Jason

  • RE: Error while trying to configure replication

    You'll also need to create a linked server for any remote server involved with replication.

    MCDBA, MCSE

    Jason

Viewing 6 posts - 1 through 6 (of 6 total)