Forum Replies Created

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

  • RE: Peer-to-peer replication and identity columns

    EdVassie (1/28/2013)


    What you want to do sounds similar to what we have done.

    We use P2P but send all our updates to a single node, which is identified using a DNS...

  • RE: Line graph not showing accurate data

    I finally resolved my issue. I was using the following expression for session properties value field which was not providing me accurate graph data.

    =Fields!CounterValue.Value

    After changing the expression to the following,...

  • RE: Line graph not showing accurate data

    The axis options are all default which are all auto for the axis range and interval settings and no options are enabled in the scale options. I'm not sure if...

  • RE: Queued Updating Subscriptions data recovery

    I'm using transactional replication with queued updatable subscriptions.

  • RE: Password mismatch error on remote connections

    Here's another twist to the problem. I can setup an odbc connection to the sql server on my desktop using the sa account and it connects successfully but I still...

  • RE: Password mismatch error on remote connections

    I have tried the IP and server name and there is only one default instance of sql server installed. There are no aliases on the server or client computer.

  • RE: Connectivity Issue

    Scott Duncan (2/19/2008)


    So what port are you connecting on? And what port is SQL Server listening on?

    From memory, if SQL Server is configured to listen on a different port...

  • RE: Connectivity Issue

    reshadit (2/19/2008)


    Dear SQL guy,

    Your issue is described vaguley. Please provide the 2 enviornments 2000 or 2005 or is both the same?

    Do you have a link account set up? ...

  • RE: Problem Deleting Maintenance Plan

    paramejunk (2/15/2008)


    Go to msdb database

    Look for the Maintenance plan you want to delete

    select * from dbo.sysdtspackages90

    Then delete it from there.

    I got rid of mine this way.

    Good...

  • RE: Problem Deleting Maintenance Plan

    Remote connections are allowed for TCP/IP and named pipes and I belong to the local administrators group.

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