Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 9,715 total)

  • RE: MSDTC / AlwaysOn

    Check the linked server itself and make sure that RPC and RPC Out are both set to TRUE.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 12:36 pm

    #1866586

  • RE: SSIS, SSMS packages - need advice

    alicesql (3/21/2016)

    So, in SQL Agent, I chose File System for the SSIS job step Package Source, and point it to the same package location that is used in VS.

    This...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 12:31 pm

    #1866584

  • RE: SSIS, SSMS packages - need advice

    alicesql (3/21/2016)

    Now I am under the impression that I must get the package back into SSMS in order to have it run as a job step in SQL Agent. ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 12:27 pm

    #1866583

  • RE: Are the posted questions getting worse?

    Alan.B (3/21/2016)

    yb751 (3/21/2016)

    SQLRNNR (3/21/2016)

    Brandie Tarvin (3/21/2016)

    Lynn Pettis (3/21/2016)

    Okay, my daughter and I are in Providence, RI. We were scheduled to do campus visit at Johnson & Wales University this...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 12:13 pm

    #1866580

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/21/2016)

    Okay, my daughter and I are in Providence, RI. We were scheduled to do campus visit at Johnson & Wales University this morning but they called yesterday...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 8:18 am

    #1866471

  • RE: SSIS package creation with txt file having multiple select statements

    below86 (3/21/2016)

    And if you don't have the rights to create the SP on the server?

    I presume the company in question would have an SDLC process to move something from Dev...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 8:13 am

    #1866467

  • RE: Are the posted questions getting worse?

    Luis Cazares (3/21/2016)

    Eirikur Eiriksson (3/21/2016)

    Brandie Tarvin (3/21/2016)

    For those of you with standing desks, ArsTechnica says it may not be helping[/url] you at all.

    Here is an alternative[/url]

    😎

    Now, that's a great idea....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 8:10 am

    #1866464

  • RE: Are the posted questions getting worse?

    For those of you with standing desks, ArsTechnica says it may not be helping[/url] you at all.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 7:49 am

    #1866453

  • RE: SSIS package creation with txt file having multiple select statements

    manoj.kumar-1078069 (3/17/2016)

    2) Loop over the record set and store each query in a variable

    Depending on how big the query is, this may not work. Variables in SSIS have a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 7:37 am

    #1866446

  • RE: SSIS package creation with txt file having multiple select statements

    below86 (3/16/2016)

    Brandie Tarvin (3/15/2016)

    aavi1011 (3/14/2016)

    App team provided select statements and want output of select statement as report in xls or csv format to thier email ID

    Is this a one off...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 21, 2016 at 7:32 am

    #1866445

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/15/2016)

    JustMarie (3/15/2016)

    Steve Jones - SSC Editor (3/15/2016)

    I'm sad today

    One bit of advice. Work with your body shop to make sure that the repairs come under...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 15, 2016 at 11:58 am

    #1865398

  • RE: Are the posted questions getting worse?

    Can someone help over on this thread? I'm positive the OP needs to rebuild SQL Server, but he seems certain that his backup strategy works and that the issue is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 15, 2016 at 10:08 am

    #1865326

  • RE: Are the posted questions getting worse?

    GilaMonster (3/15/2016)

    Ed Wagner (3/15/2016)

    GilaMonster (3/15/2016)

    Brandie Tarvin (3/15/2016)

    In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 15, 2016 at 5:40 am

    #1865176

  • RE: SSIS package creation with txt file having multiple select statements

    aavi1011 (3/15/2016)

    Yes I know,But creating Sp's in production,DBA need to get more permissions,Need to take this to other level.

    It sounds as if you've never used Data Flow Tasks given your...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 15, 2016 at 5:38 am

    #1865175

  • RE: SSIS package creation with txt file having multiple select statements

    aavi1011 (3/15/2016)

    This need to happen daily.

    Do you know how to create an SSIS package?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    March 15, 2016 at 4:08 am

    #1865156

Viewing 15 posts - 1,951 through 1,965 (of 9,715 total)