Forum Replies Created

Viewing 15 posts - 4,261 through 4,275 (of 7,164 total)

  • RE: ODBC Connection to SQLServer Error: 10060

    I do not think you can connect to a SQL 2012 instance with SSMS 2008.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to convert DTS Pack. to SSIS

    jerry-621596 (4/27/2012)


    This is an article that presents options that you can try.

    http://msdn.microsoft.com/en-us/library/cc768544(v=sql.100).aspx

    Nice 🙂 The article was written by Brian Knight, who works(ed?) for Pragmatic Works, producer of DTS xChange. I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to convert DTS Pack. to SSIS

    > Third party tools can help. Here is one: DTS xChange is an enterprise ready tool to convert DTS packages to SSIS 2005/2008 with very little manual effort. DTS xChange...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: ODBC Connection to SQLServer Error: 10060

    No worries on the 2012 thing, now that we know, it'll be easy to get you some help.

    You need the SQL 2012 Client Development Tools. You can get them here:...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: just curious

    Sean Lange (4/27/2012)


    Keep in mind that none of us (or at least most of us) did not get the opportunity to see your now retracted comment. Perhaps the guilt of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: ODBC Connection to SQLServer Error: 10060

    You posted in a SQL 2008 forum, so to be sure, is it a SQL 2008 or 2008R2 instance we're talking about? If so, your error message says DBNETLIB which...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: just curious

    Sean Lange (4/27/2012)


    opc.three (4/27/2012)


    Sean Lange (4/27/2012)


    opc.three (4/27/2012)


    Lynn Pettis (4/27/2012)


    opc.three (4/27/2012)


    ...on second thought...comment removed...

    Dang, had three minutes to see what you said and I missed it. 😛

    Yeah...for once I need...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: ODBC Connection to SQLServer Error: 10060

    Sounds like you need to enable remote connections. If value_in_use is 0 for this:

    SELECT name,

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SQL Server Locking Up

    dwilliscp (4/27/2012)


    My boss is against setting the Max Memory... so until I can Prove the effect of MS recommended setting.. I will just have to monitor.

    Sounds like you need a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: just curious

    Sean Lange (4/27/2012)


    opc.three (4/27/2012)


    Lynn Pettis (4/27/2012)


    opc.three (4/27/2012)


    ...on second thought...comment removed...

    Dang, had three minutes to see what you said and I missed it. 😛

    Yeah...for once I need to stop violating...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: just curious

    Lynn Pettis (4/27/2012)


    opc.three (4/27/2012)


    ...on second thought...comment removed...

    Dang, had three minutes to see what you said and I missed it. 😛

    Yeah...for once I need to stop violating my rule about...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: just curious

    ...on second thought...comment removed...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: just curious

    Lynn Pettis (4/27/2012)


    ColdCoffee (4/27/2012)


    I guess the OP wants to know why NULL cannot be used with = operator but can be used with the keyword IS

    Riya_dave, it depends on this...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Database Owner Unkown

    NaCl (4/27/2012)


    not so sure i agree with setting all DB owners to SA.

    This is a discussion Forum, all opinions are welcome. Care to share why not?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: just curious

    LIKE

    Equals (=)

    Both are used for comparisons.

    This makes no sense:

    = (@maxdate = null)

    And neither does what you tried to do:

    like (@maxdate = null)

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 4,261 through 4,275 (of 7,164 total)