Forum Replies Created

Viewing 15 posts - 3,676 through 3,690 (of 7,168 total)

  • RE: data pump into MySQL

    CozyRoc (6/29/2012)


    I disagree. It is included in the product so does not require a cash outlay.

    The solution you present requires extra cash outlay in the contractor pocket who is doing...

  • RE: data pump into MySQL

    CozyRoc (6/29/2012)


    opc.three (6/29/2012)


    Here is an example for you. It requires no third party components and modification of only a few lines of VB.net code to get working with your chosen...

  • RE: data pump into MySQL

    Here is an example for you. It requires no third party components and modification of only a few lines of VB.net code to get working with your chosen ODBC connection,...

  • RE: backup thread in a wiat state for the last 2 days.

    Ultimately it is your call but I do not anticipate any issues with killing those threads in terms of you ending up with a corrupt database, but it is master...

  • RE: SQL Server Certs

    Lynn Pettis (6/29/2012)


    opc.three (6/29/2012)


    Lynn Pettis (6/29/2012)


    I can think of at least one person on SSC that would disagree, but I'll leave it to Brandie to explain why.

    I am curious to...

  • RE: Column property change

    jdbrown239 (6/29/2012)


    Thanks opc.three that helped alot.

    You're welcome, have a good weekend.

  • RE: backup thread in a wiat state for the last 2 days.

    BACKUPIO - Occurs when a backup task is waiting for data, or is waiting for a buffer in which to store data. This type is not typical, except when a...

  • RE: SQL Server Certs

    Lynn Pettis (6/29/2012)


    I can think of at least one person on SSC that would disagree, but I'll leave it to Brandie to explain why.

    I am curious to hear her thoughts....

  • RE: SQL Server Certs

    BKF (6/29/2012)


    I need to obtain the SQL Server 2008 Implementation and Maintenance cert ASAP

    Who or what is creating this sense of urgency?

    Can anyone give me an idea how best to...

  • RE: backup thread in a wiat state for the last 2 days.

    Any other threads on the instance with a different backup wait type, e.g.

    BACKUP - Occurs when a task is blocked as part of backup processing.

    BACKUP_CLIENTLOCK - Internal only.

    BACKUP_OPERATOR -...

  • RE: data pump into MySQL

    With SSIS 2008/2012 it is easy using a builtin component, but with 2005, sadly, it is not. Check Pragmatic Works for a third party component. I think they have one...

  • RE: data pump into MySQL

    cmoy (3/23/2012)


    I have massive amounts of data that I need to put from 2008 into MySQL every hour. I would like to invoke MySQL's LOAD Data functionality (somewhat equivalent...

  • RE: How Can I Update Data From An Email Attachment ?

    clucasi (6/11/2012)


    I need to update SQL 2005 from an email attachment, which is a delimited Excel 2010 file. The same named file is delivered to me with updated data throughout...

  • RE: How to determine when column stats are updated?

    GilaMonster (6/29/2012)


    opc.three (6/29/2012)


    You may have something very granular or customizable planned in terms of your scripting effort so this may not be applicable, or these options may not satisfy your...

Viewing 15 posts - 3,676 through 3,690 (of 7,168 total)