Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 8,753 total)

  • RE: Column 'x' is invalid in the select list because it is not contained in either an aggregate function

    Quick thought, you cannot mix group by and window function (over clause), not compatible!

    😎

    April 3, 2015 at 10:35 am

    #1788617

  • RE: XP_cmdshell DIR

    I know I'm somewhat late to the show, haven't read through the whole trail and therefore might be missing something, but my approach would be the xp_cmdshell with "dir...

    April 3, 2015 at 10:22 am

    #1788614

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/3/2015)

    SqlSanctum (4/3/2015)

    Brandie Tarvin (4/3/2015)

    #HEADDESK

    Don't you just love it when you go to post a question to the forums (after banking your head against a wall for several hours /...

    April 3, 2015 at 10:12 am

    #1788611

  • RE: Problem with Flat file connection manager

    Lynn Pettis (4/3/2015)

    Eirikur Eiriksson (4/3/2015)

    Koen Verbeeck (4/3/2015)

    SQLRNNR (4/3/2015)

    Koen Verbeeck (4/3/2015)

    Eirikur Eiriksson (4/3/2015)

    sqlmaverick (4/2/2015)

    Hi all,

    I have to eliminate comma in last field of a file in flat file connection manager. when...

    April 3, 2015 at 10:05 am

    #1788609

  • RE: Charindex issue

    Thanks Alan for this, I was about to do the same when I saw your post, good job!

    😎

    April 3, 2015 at 10:02 am

    #1788608

  • RE: The owner () of job <Job Name> does not have server access problem

    jasona.work (4/3/2015)

    Eirikur Eiriksson (4/3/2015)

    jasona.work (4/3/2015)

    Looks like that site might be showing an older version of the STIG then.

    The date on the one you linked to is 6-23-2014, the date on...

    April 3, 2015 at 9:41 am

    #1788603

  • RE: HELP! SQL Server 2008R2 - Spatial Data (Geography) - SUPER SLOW!

    A good resource is Pro Spatial with SQL Server 2012 By Alastair Aitchison

    well worth the money

    😎

    April 3, 2015 at 8:37 am

    #1788577

  • RE: Problem with creating a Index on a temp table

    Quick thought on the naming, although as Gail stated the index names do not have to be unique unless in the scope of a table, it often makes life easier...

    April 3, 2015 at 8:34 am

    #1788576

  • RE: Today's Random Word!

    SQLRNNR (4/3/2015)

    Eirikur Eiriksson (4/3/2015)

    djj (4/3/2015)

    jasona.work (4/3/2015)

    Eirikur Eiriksson (4/3/2015)

    crookj (4/3/2015)

    djj (4/3/2015)

    SQLRNNR (4/2/2015)

    Revenant (4/2/2015)

    Ed Wagner (4/2/2015)

    djj (4/2/2015)

    whereisSQL? (4/2/2015)

    SQLRNNR (4/2/2015)

    BWFC (4/2/2015)

    Exhibition

    Exhibitionist

    Voyuer

    Voyager

    Space

    Balls

    Get some NUTS! (Mr. T snickers commercials)

    Squirrel

    Girl

    Gender

    Flexible

    Hose

    Flush

    toilet

    Porcelain

    April 3, 2015 at 8:27 am

    #1788571

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (4/3/2015)

    SqlSanctum (4/3/2015)

    No, it was never rescinded after Vatican II, almost everyone thinks it was though. Even my mother didn't believe me when I told her. I've had confirmation...

    April 3, 2015 at 8:26 am

    #1788570

  • RE: Problem with Flat file connection manager

    Koen Verbeeck (4/3/2015)

    SQLRNNR (4/3/2015)

    Koen Verbeeck (4/3/2015)

    Eirikur Eiriksson (4/3/2015)

    sqlmaverick (4/2/2015)

    Hi all,

    I have to eliminate comma in last field of a file in flat file connection manager. when I check the source...

    April 3, 2015 at 8:22 am

    #1788564

  • RE: Error Handling

    Quick thought, recommend adding a check for error message 1205 and a retry in case of a deadlock

    😎

    April 3, 2015 at 8:11 am

    #1788558

  • RE: Today's Random Word!

    crookj (4/3/2015)

    Eirikur Eiriksson (4/3/2015)

    djj (4/3/2015)

    jasona.work (4/3/2015)

    Eirikur Eiriksson (4/3/2015)

    crookj (4/3/2015)

    djj (4/3/2015)

    SQLRNNR (4/2/2015)

    Revenant (4/2/2015)

    Ed Wagner (4/2/2015)

    djj (4/2/2015)

    whereisSQL? (4/2/2015)

    SQLRNNR (4/2/2015)

    BWFC (4/2/2015)

    Exhibition

    Exhibitionist

    Voyuer

    Voyager

    Space

    Balls

    Get some NUTS! (Mr. T snickers commercials)

    Squirrel

    Girl

    Gender

    Flexible

    Hose

    Flush

    Royal

    Blue

    April 3, 2015 at 8:06 am

    #1788554

  • RE: SQL Server Agent Job

    Admingod (4/2/2015)

    How to configure alert when SQL Server Agent Job gets disabled. I want to get notified when Agent Job gets disabled. Let me know if you have done something...

    April 3, 2015 at 7:54 am

    #1788548

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (4/3/2015)

    Grant Fritchey (4/3/2015)

    Sean Lange (4/3/2015)

    Grant Fritchey (4/3/2015)

    Koen Verbeeck (4/3/2015)

    It's Friday and I'm grumpy...

    http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx

    OK. Funny, very funny, but a little uncool.

    I found it a rather fitting response to somebody...

    April 3, 2015 at 7:51 am

    #1788545

Viewing 15 posts - 5,821 through 5,835 (of 8,753 total)