Forum Replies Created

Viewing 15 posts - 4,171 through 4,185 (of 9,722 total)

  • RE: Down grade from enterprise to standard in sql 2008r2

    The easiest (and only) way to downgrade is a completely new installation. I've never heard of being able to change the version any other way.

    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.

    July 18, 2012 at 11:29 am

    #1514387

  • RE: SSIS Data Conversion

    Glad you got it working. SSIS can be frustrating at the best of times.

    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.

    July 18, 2012 at 11:28 am

    #1514386

  • RE: Name the things that were supposed to cause the End Of The World

    venoym (7/18/2012)

    Lowell (7/16/2012)

    Brandie Tarvin (7/16/2012)

    Lowell (7/16/2012)

    And Whatever ever happened to the killer bees that were supposed to kill everyone along the US border as they migrated north?

    I thought that was...

    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.

    July 18, 2012 at 8:39 am

    #1514263

  • RE: xp_cmdshell problem

    UnicornsRreal (7/18/2012)

    Did anyone find a solution to this?

    Start a new thread with all relevant details (including the answers to the questions on this thread). You'll get more hits that way....

    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.

    July 18, 2012 at 7:26 am

    #1514200

  • RE: Need help on a Sql Query

    SQLKnowItAll (7/16/2012)

    Brandie Tarvin (7/16/2012)

    The asterick isn't helping you much, either. Try breaking that down to individual column names.

    Although I am not a fan of using *, how will eliminating that...

    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.

    July 16, 2012 at 12:17 pm

    #1513247

  • RE: Need help on a Sql Query

    Unfortunately, you can't have both fast inserts and fast reads. You're going to have to pick one or the other, fast inserts and slow reads or slower inserts and faster...

    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.

    July 16, 2012 at 10:33 am

    #1513205

  • RE: Name the things that were supposed to cause the End Of The World

    Lowell (7/16/2012)

    And Whatever ever happened to the killer bees that were supposed to kill everyone along the US border as they migrated north?

    I thought that was Bird Flu ... or...

    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.

    July 16, 2012 at 7:56 am

    #1513079

  • RE: Name the things that were supposed to cause the End Of The World

    Lynn Pettis (7/3/2012)

    Mr. Celko actually posting a helpful reply!

    Already happened once. We're still here.

    A little singed, but still here.

    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.

    July 16, 2012 at 7:56 am

    #1513078

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/16/2012)

    mtillman-921105 (7/11/2012)

    'Guess it's time for me to pu away my aluminum floil[/url] now. MIT has researched the effectiveness of tin foil hats. :w00t:

    [edited link]

    Heh... their testing was...

    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.

    July 16, 2012 at 7:53 am

    #1513077

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (7/15/2012)

    Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and Gus ...

    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.

    July 16, 2012 at 7:50 am

    #1513075

  • RE: Today's Random Word!

    Is GAH a word? If so, that's my random word of the day.

    GAH!

    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.

    July 16, 2012 at 7:27 am

    #1513057

  • RE: Add Job History Manually..??

    Don't have the packages kick off child packages. Have the SQL Job run each individual package (even the "child packages") as individual steps that only run if the "parent" 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.

    July 16, 2012 at 7:23 am

    #1513053

  • RE: Changing @LastUpload to @LastMonth

    Is it just me or does the last bit of code have an extra single quote mark? Or maybe is missing one?

    Also, please explain to me how @last_upload is not...

    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.

    July 16, 2012 at 7:21 am

    #1513052

  • RE: Need help on a Sql Query

    EDIT: changed question.

    Why are you using LIKEs using wildcards on both sides of the keyword? You do it 3 times.

    Also, you added a table to Scott's original query in 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.

    July 16, 2012 at 7:07 am

    #1513046

  • RE: Adding Values between Two Dates

    Arman Khan (7/11/2012)

    Hi.

    I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate.

    For Example:

    =SUM(

    IIF(Fields!rpt_date.Value = Parameters!RptDate.Value

    And Fields!Mot.Value...

    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.

    July 13, 2012 at 12:40 pm

    #1512685

Viewing 15 posts - 4,171 through 4,185 (of 9,722 total)