Forum Replies Created

Viewing 15 posts - 4,861 through 4,875 (of 9,722 total)

  • RE: Importing an existing Excel file into a table

    Given Excels lack of true data types, I am not a big fan of the OPENROWSET approach to your problem. I've seen more than than enough problems with numbers being...

    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.

    January 19, 2012 at 7:05 am

    #1435813

  • RE: Today's Random Word!

    Daniel Bowlin (1/19/2012)

    SQLRNNR (1/18/2012)

    crookj (1/18/2012)

    WOTD - misnomer

    miss gomer

    Miss Daisy

    Miss U

    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.

    January 19, 2012 at 6:53 am

    #1435800

  • RE: Are the posted questions getting worse?

    If I've already announced this here, I apologize for the repost. I'm just so excited I can't remember where all I've shared the news already.

    I am beyond thrilled today 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.

    January 19, 2012 at 5:19 am

    #1435744

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (1/18/2012)

    SQLRNNR (1/18/2012)

    anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

    I have been able to copy...

    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.

    January 19, 2012 at 5:10 am

    #1435740

  • RE: SQL Agent Job succeeds even though step should fail

    I did not know that information about the timeout. I'll check into it.

    Of course, every time I get a moment to work on this issue, another bigger fire comes out...

    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.

    January 18, 2012 at 12:27 pm

    #1435446

  • RE: search query as per selected checkboxes

    I'm glad we were able to help.

    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.

    January 18, 2012 at 12:26 pm

    #1435444

  • RE: Are the posted questions getting worse?

    In case anyone is interested, the text of SOPA (the House bill) can be found here: http://www.gpo.gov/fdsys/pkg/BILLS-112hr3261ih/pdf/BILLS-112hr3261ih.pdf

    The text of PIPA (the Senate bill) can be found here:

    http://www.opencongress.org/bill/112-s968/text

    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.

    January 18, 2012 at 12:02 pm

    #1435435

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/15/2012)

    GilaMonster (1/14/2012)

    I've seen Transcender sample tests before, they're miles from the real exams.

    Then, totally switching gears, are such sample tests actually helping to learn those things necessary 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.

    January 16, 2012 at 4:55 am

    #1433989

  • RE: SetUp Mail Notifications with Jobs failure

    olingerd (1/13/2012)

    HI Brandie,

    It looks like everything is fine and I am able to send a test email successfully but still no email job notification upon job completion (and yes 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.

    January 13, 2012 at 9:59 am

    #1433409

  • RE: SetUp Mail Notifications with Jobs failure

    thotvedt (1/13/2012)

    This is a great alternative to setting up mail notifications on jobs without using SQL mail. It does have some limitations, but for failure/success notifications, it's great. And it's...

    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.

    January 13, 2012 at 9:18 am

    #1433349

  • RE: syntax error???

    jbalbo (1/13/2012)

    Wow never picked it up!!

    It's probably the most common sql server mistake ever made and everyone, even the experts, make it constantly. Just remember: If everything else looks correct,...

    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.

    January 13, 2012 at 9:14 am

    #1433338

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/13/2012)

    What's the general feeling about asking Steve to remove that "Question for the Experts" thread? +1 vote here.

    I was going to ask him to lock 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.

    January 13, 2012 at 7:14 am

    #1433230

  • RE: Are the posted questions getting worse?

    Can someone who knows more about C# help out here?

    He's passing code to SQL Server and not getting things to work. I'm half out of my depth and half too...

    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.

    January 13, 2012 at 7:13 am

    #1433229

  • RE: SetUp Mail Notifications with Jobs failure

    You've followed all the steps below?

    Microsoft's DBMail Wizard Steps

    Pinal Dave has a more user-friendly version here[/url].

    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.

    January 13, 2012 at 6:46 am

    #1433195

  • RE: search query as per selected checkboxes

    HemSingh (1/13/2012)

    Brandie Tarvin (1/13/2012)

    I refer you back to my last response.

    Use IN instead of = on the stored procedure and concatenate the values together......

    Hi Brandie Tarvin,

    I am trying yr...

    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.

    January 13, 2012 at 6:36 am

    #1433186

Viewing 15 posts - 4,861 through 4,875 (of 9,722 total)