Forum Replies Created

Viewing 15 posts - 4,801 through 4,815 (of 7,164 total)

  • RE: Error when attempting to connecting to SSIS via SSMS

    Relevant?

    A short story about the "SSIS Service that Failed to start ".

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Replication for redundancy

    2cool222 (3/26/2012)


    Thanks for your help. Database name are same in A and B both server. I will try to change it at subsciber level if that works.

    Anytime, happy...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Replication for redundancy

    As long as database names on A are not overlapping with any database names on B then you can use continuous Transaction Replication to achieve your goal of having all...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Error when attempting to connecting to SSIS via SSMS

    I just tried it on one of my servers and DTUtil can delete packages from the server without having the SSIS services on:

    dtutil /SourceS server_name_here /SQL "[\PathToPackage]\PackageName" /Del

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Error when attempting to connecting to SSIS via SSMS

    <stupid forum cross-posted>

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Error when attempting to connecting to SSIS via SSMS

    I said "may" because I was not sure if DTUtil requires the SSIS service to be up. If the services are down, all bets are off. But if you're just...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: release management tools

    VISUAL STUDIO TEAM FOUNDATION SERVER 2010

    Microsoft Visual Studio Team Foundation Server 2010 is the collaboration platform at the core of Microsoft’s application lifecycle management (ALM) solution. Team Foundation Server 2010...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Error when attempting to connecting to SSIS via SSMS

    DTUtil.exe may work for you in this scenario.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Going from individual user access to Security Group access best practices

    dbdmora (3/26/2012)


    I am taking over a bunch of database servers where in the past if anyone needed access to a SQL Server they would add the individual domain name to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Replication for redundancy

    OK, from your original post:

    If server A goes down, server B can replicate to C and D. similarly if server B goes down, server A can replicate to C...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SQL Server 2005 page life concern

    opc.three (3/14/2012)


    Lynn Pettis (3/14/2012)


    Not sure if AWE is going to help here. The /3GB switch should.

    No evidence of helping or hurting in terms of making more memory avaialble. But...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Memory - Total/Target always using same value?

    george sibbald (3/23/2012)


    thanks opc, Thats better, now we have proof.

    Just to complete the picture:

    Indeed, for completeness...

    what does task manager say SQL is using ?

    Only ~80MB. At first glance this may...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Replication for redundancy

    Sorry, your setup is unclear to me.

    A and B are on the same network collecting online data. Both machine are collecting same data.

    By "Both machine are collecting same data."...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Generate insert statement from table

    TheSQLGuru (3/23/2012)


    opc.three (3/22/2012)


    The SSMS Tools Pack has a built-in feature to help you generate INSERT statements from a table, or even from a specific query...very handy.

    SSMS Tools Pack > Generate...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Memory - Total/Target always using same value?

    So I just ran a bunch of queries to warm up the buffer pool and got the committed memory up to 2.44GB with "AWE on, 3GB off"

    physical mem, VAS, buffer...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 4,801 through 4,815 (of 7,164 total)