Forum Replies Created

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

  • RE: Stored Procedure taking more time to execute (Sql Server 2005)

    Happy to hear things are improving...please help us help you...

    opc.three (4/26/2012)


    It looks like you could benefit from an index on Users.ID that INCLUDEs email but I need to see the...

  • RE: ODBC Connection to SQLServer Error: 10060

    I see you mentioned the Native Client 10.0, not SSMS...you may be able to use the SQL 2008 Native Client to create an ODBC DSN that will connect to 2012,...

  • RE: ODBC Connection to SQLServer Error: 10060

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

  • 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...

  • 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...

  • 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:...

  • 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...

  • 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...

  • 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...

  • 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,

    ...

  • 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...

  • 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...

  • 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...

  • RE: just curious

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

  • 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...

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