Forum Replies Created

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

  • RE: Are the posted questions getting worse?

    GAH.

    Late night release last night. The vendor copied and pasted SQL code from a Word doc into the T-SQL job step. Of course the single quotes are "smart quotes" so...

    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 23, 2016 at 4:24 am

    #1867017

  • RE: Books Online / Stupid Help Viewer

    Someone mentioned a setting in a post without mentioning if it was a server, database, or object level setting. I wanted to plug in that phrase and see what popped...

    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 22, 2016 at 7:59 am

    #1866787

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/22/2016)

    In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all of the commotion...

    I didn't realize you worked in Brussels. Glad...

    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 22, 2016 at 6:06 am

    #1866728

  • RE: Are the posted questions getting worse?

    BL0B_EATER (3/22/2016)

    Does anyone else have an issue during submitting an article when you paste in some TSQL into the SQL snippet block and save it then go back to it...

    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 22, 2016 at 4:06 am

    #1866695

  • RE: MSDTC / AlwaysOn

    JeremyE (3/21/2016)

    Distributed transactions for AlwayOn will be supported in SQL 2016 but not SQL 2012.

    https://msdn.microsoft.com/en-us/library/ms366279(v=sql.110).aspx

    Really?

    Thank you for that information, Jeremy.

    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 22, 2016 at 4:04 am

    #1866693

  • 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

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