Forum Replies Created

Viewing 15 posts - 691 through 705 (of 9,715 total)

  • RE: Object variables, ADO Recordsets, & decrypting column

    Thanks, Jack. I'll look over the links.

    Regarding the .dll, someone else built it for this purpose. I'm not sure if it was the vendor or one of our...

    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.

    May 30, 2018 at 7:18 am

    #1992293

  • RE: Object variables, ADO Recordsets, & decrypting column

    Bumping the post because I have received no answers for the last question. I've switched back to trying to use the .dll in a Script Task (rather than a Script...

    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.

    May 30, 2018 at 4:55 am

    #1992272

  • RE: Object variables, ADO Recordsets, & decrypting column

    Jack Corbett - Friday, May 25, 2018 7:54 AM

     This article is a pretty good explanation of how to do...

    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.

    May 25, 2018 at 11:58 am

    #1992020

  • RE: Object variables, ADO Recordsets, & decrypting column

    Actually I had just created the Script Task on the Control Flow. Do you think a Data Flow task would be better for this?

    I'm a little worried about...

    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.

    May 25, 2018 at 8:02 am

    #1991972

  • RE: Are the posted questions getting worse?

    Oy! I get all the fun projects. I love a challenge. I don't love being on a deadline to learn a new programming language, though.

    Any advice on decrypting...

    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.

    May 25, 2018 at 7:41 am

    #1991969

  • RE: Proposed: Closing old forums

    I think it would be nice to archive off the older SQL version forums so the threads are still available even if the posting ability is not.

    I...

    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.

    May 25, 2018 at 7:39 am

    #1991968

  • RE: Are the posted questions getting worse?

    Hola, Fellow Threadzians.

    As I push my head above dense project waters to grab a breath of fresh air, I was wondering if anyone would care to assist me...

    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.

    May 23, 2018 at 12:42 pm

    #1991688

  • RE: SSMS Solution queries prompt HRESULT E_FAIL error when trying to connect to servers

    I probably shouldn't have used the word "upgraded." I did get a new box entirely, fresh install of the OS.

    Sorry for the length of time to respond 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.

    May 15, 2018 at 12:46 pm

    #1990588

  • RE: How can i give Grant permission for synonyms from another database in same server.

    Salil-386686 - Wednesday, March 14, 2018 11:40 PM

    As long as the owner for the both the databases is same, you only need...

    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, 2018 at 4:57 am

    #1983353

  • RE: Weird variables / expressions issue

    tim.ffitch 25252 - Monday, February 26, 2018 9:35 AM

    The connection string expression may make sense if package reads from a parameter...

    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.

    February 26, 2018 at 11:19 am

    #1981153

  • RE: Weird variables / expressions issue

    The worst part about it is the people who were developing this code kept insisting on turning SQL tables into flat files and doing stupid stuff like that, no matter...

    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.

    February 23, 2018 at 10:55 am

    #1980971

  • RE: Grouping dates and IDs together

    Thanks, Drew. I was working on that, but changing different items in the CASE. I'll take a look at that and see how it works.

    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.

    February 13, 2018 at 5:12 am

    #1979576

  • RE: Grouping dates and IDs together

    drew.allen - Monday, February 12, 2018 12:12 PM

    Brandie Tarvin - Monday, February 12, 2018 11:46 AM

    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.

    February 12, 2018 at 12:27 pm

    #1979502

  • RE: Grouping dates and IDs together

    Lynn Pettis - Monday, February 12, 2018 11:50 AM

    Brandie Tarvin - Monday, February 12, 2018 11:46 AM

    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.

    February 12, 2018 at 12:16 pm

    #1979495

  • RE: Grouping dates and IDs together

    BAH. I thought I was through with this, but I just found an outlier.

    When testing with the this data:

    INSERT INTO #MyTemp (Office, POID, DeliverySite,...

    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.

    February 12, 2018 at 11:46 am

    #1979482

Viewing 15 posts - 691 through 705 (of 9,715 total)