Forum Replies Created

Viewing 9 posts - 61 through 69 (of 69 total)

  • RE: Index Blocking Issue

    The Gurus have already given their advices and i totally agree with them.

    But just a thought which comes to my mind, if you are reporting off your production database throughout...

  • RE: Unable to connect to default database

    Looks like the login credintials used to register the server in your enterprise manager are no longer valid or do not exist.

    Try connecting directly via Query Analyzer.

    or

    Check the login in...

  • RE: SQL Server Replication with SS2K Publisher and SS2K5 Subscriber

    I have never worked on this scenario ( 2K publisher and 2005 subscriber), but here is what i think about it:-

    1. Did you run the snapshot agent and apply the...

  • RE: SQL Express as a remote distributor Transactional Replication

    What do you mean by "witness"? i thought "witness" is available only in case of mirroring and logshipping.

    If you meant having publisher and distributor on the same box, then following...

  • RE: replication - enabled subscribers

    What happens if you explicitly say "Add Subscriber", then add your 2005 server using IP address and the remote login.

    Are you able to do this ?

  • RE: Dropping Article

    Re-initializing is only required for Merge Replication and more to it if the following conditions are true :-

    From BOL

    1. If an article is a parent article in a join filter...

  • RE: report text location on maintenance plan on sqlserver 2005

    You can find "Reporting and Logging" button next to "Manage Connections...".

  • RE: SPN SQL Server 2005?

    SPN is service principal name which gets registered when you install the sql server running under X account. The SPN is registered under that X account. When you change your...

  • RE: snapshot agent failure

    In the publication property > Snapshot, one would indicate where the generated snapshot should be stored. Change the path over here to a valid one.

    Also, View Details ( in replication...

Viewing 9 posts - 61 through 69 (of 69 total)