Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 9,725 total)

  • RE: Date Error

    You have two different date formats in your sample code. Unless you have a way for SQL to auto-identify which log strings contain which date formats, you're going to continually...

    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.

    November 10, 2014 at 12:06 pm

    #1757522

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/7/2014)

    Brandie Tarvin (11/7/2014)

    Can someone please help me here? I am having a very bad week, so I'm about to lose my temper with Stewart because he wants to...

    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.

    November 7, 2014 at 7:05 am

    #1757202

  • RE: SSIS Execute Package Task Setup Question

    Koen Verbeeck (11/7/2014)

    Ah, so not a permission issue after all 😀

    I knew it wasn't. I just couldn't figure out how to create the correct connection manager. Now I'm kicking myself...

    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.

    November 7, 2014 at 7:02 am

    #1757200

  • RE: SSIS Execute Package Task Setup Question

    Brandie Tarvin (11/7/2014)

    Koen Verbeeck (11/7/2014)

    Is the package stored on the machine itself, or on a UNC path?

    The package is stored on the machine itself under D:\SQLServer\MSSQL10\100\DTS\Packages\My Folder\. In Integration Services...

    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.

    November 7, 2014 at 6:39 am

    #1757193

  • RE: SSIS Execute Package Task Setup Question

    Koen Verbeeck (11/7/2014)

    Does it already fail in BIDS?

    Yes. In fact, I haven't gotten past BIDS to running it from the GUI or a job. What I'm doing is running the...

    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.

    November 7, 2014 at 6:35 am

    #1757190

  • RE: Are the posted questions getting worse?

    Can someone please help me here? I am having a very bad week, so I'm about to lose my temper with Stewart because he wants to focus on security issues...

    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.

    November 7, 2014 at 6:08 am

    #1757184

  • RE: SSIS Execute Package Task Setup Question

    Stewart, I have been a DBA for over 10 years. Please give me a little credit for knowing the basics.

    Can we please get to the question I am asking?

    EDIT: And...

    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.

    November 7, 2014 at 6:00 am

    #1757181

  • RE: SSIS Execute Package Task Setup Question

    I am not asking a question about permissions. I am asking about how to set up the connection manager.

    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.

    November 7, 2014 at 5:36 am

    #1757172

  • RE: Google shutting down SQL Error Searches?

    The odd thing is that I've gotten this response when researching BIDS / Visual Studio errors too. This was last week and I don't recall anything that had variable names...

    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.

    October 17, 2014 at 12:26 pm

    #1753245

  • RE: Who Watches the Watchers?

    Gary Varga (10/16/2014)

    IMHO (10/16/2014)

    In answer to the question Who Watches the Watchers...robots.

    ...CCTV???

    Max Headroom.

    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.

    October 16, 2014 at 8:48 am

    #1752891

  • RE: Who Watches the Watchers?

    Talk about article timing. Have any of you seen this?

    http://arstechnica.com/security/2014/09/home-depots-former-security-architect-had-history-of-techno-sabotage/%5B/url%5D

    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.

    October 16, 2014 at 4:36 am

    #1752791

  • RE: Execute Permission denied on xp_sqlagent_enum_jobs between databases

    BAH! All the settings are the same between both servers. Pics attached.

    I'm beginning to think I'm fighting a losing battle here and might have to go with just selecting data...

    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.

    September 24, 2014 at 8:26 am

    #1747855

  • RE: Execute Permission denied on xp_sqlagent_enum_jobs between databases

    Lynn Pettis (9/19/2014)

    Compare the MSDTC settings between two working systems (one being the one you are trying to run the procedure from) and between the two systems that aren't working....

    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.

    September 24, 2014 at 4:31 am

    #1747767

  • RE: Where Did The Women Go?

    Thanks for that link, Paul. It's an interesting article with a very good point.

    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.

    September 23, 2014 at 8:19 am

    #1747489

  • RE: Where Did The Women Go?

    Ah. I assumed you were in a U.S. company. My bad.

    I understand the strange working hours better now, though. I assume most of the companies you do work for are...

    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.

    September 22, 2014 at 10:41 am

    #1747184

Viewing 15 posts - 3,076 through 3,090 (of 9,725 total)