Forum Replies Created

Viewing 15 posts - 541 through 555 (of 3,232 total)

  • RE: Are the posted questions getting worse?

    I would pay money to see the look on my own face if I heard any of that stuff come out of anybody's mouth in an SSIS discusion. Priceless....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 9, 2010 at 6:27 pm

    #1149441

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/8/2010)

    Here's one for y'all.

    That one will go down as one of the best threads ever. One could only hope the OP memorized the answers actually uses them in...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 9, 2010 at 6:16 pm

    #1149439

  • RE: Today's Random Word!

    Crapwand

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 8, 2010 at 10:10 am

    #1148436

  • RE: Incorrect syntax near the keyword 'IF'.

    Ah, now I see. You cannot use an IF construct with an INSERT statement. Look in BOL for INSERT; it must be INSERT INTO....VALUES or INSERT INTO.....SELECT.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 7, 2010 at 9:59 am

    #1147498

  • RE: Incorrect syntax near the keyword 'IF'.

    The syntax looks fine to me. You are using variables in your SQL, did you declare them first?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 7, 2010 at 9:39 am

    #1147468

  • RE: SSIS Package to Import Image Type Data with Fast to a Remote Database Server

    It sounds to me like the problem is not the SSIS packge, but transferring data over the WAN. You mentioned that the packge was very fast when used over...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 7, 2010 at 8:44 am

    #1147392

  • RE: How many of you have done Certification for SQL Server?

    Tom.Thomson (4/6/2010)

    John Rowan (4/6/2010)

    This was actually SS2000 EM and my meaning is that he was completely unaware of how to use the GUI to backup a database. Not that...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 7, 2010 at 8:35 am

    #1147379

  • RE: How many of you have done Certification for SQL Server?

    This was actually SS2000 EM and my meaning is that he was completely unaware of how to use the GUI to backup a database. Not that I'm that proficient...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 6, 2010 at 4:30 pm

    #1146880

  • RE: How many of you have done Certification for SQL Server?

    For the record, no certs or degrees here. The only people that I've run accross that have certs and actually know what they are talking about is out here...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 6, 2010 at 4:13 pm

    #1146868

  • RE: SSIS Package to Import Image Type Data with Fast to a Remote Database Server

    I'm with Elliot here, we need more info on what you've already done. In addition to what Elliot has asked for, can you give us an explanation of how...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 6, 2010 at 3:58 pm

    #1146856

  • RE: SP_GetApplock - Understanding what is being locked

    Bill, your explanation of how app locks work is accurate. App locks do nothing more than allow you to micro-manage an application 'resource' using SQL Server's locking memory space....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 5, 2010 at 12:10 pm

    #1145923

  • RE: Today's Random Word!

    dbowlin (4/2/2010)

    Here comes the sun!

    Here comes the Son! Have a Happy Easter weekend everyone!

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 2, 2010 at 11:48 am

    #1144994

  • RE: Problem converting DTS funtionality to SSIS

    No problem.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 1, 2010 at 12:55 pm

    #1144387

  • RE: Problem converting DTS funtionality to SSIS

    Yea, that may work. If you set up a DB on your SSIS server to use for this. You could also do this in 2 data flows. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 1, 2010 at 12:28 pm

    #1144372

  • RE: Problem converting DTS funtionality to SSIS

    SQL Server 2000 will not support ROW_NUMBER(). Is your destination a SS2005 box?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 1, 2010 at 12:20 pm

    #1144367

Viewing 15 posts - 541 through 555 (of 3,232 total)