Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Identity_column Expand / Collapse
Author
Message
Posted Friday, July 17, 2009 11:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 24, 2012 8:10 AM
Points: 2,042, Visits: 499
Actually the answer is "NONE OF THE ABOVE". The answer (deemed correct) refers to IDENTITY INSERT set to ON. This query will run if IDENTITY INSERT is set to on. However, it is off. The actual error message refers to IDENTITY INSERT SET TO OFF. Minor verbiage change, but can make a big difference (several previous questions had details like this that made the difference between right and wrong so consistency should be maintained).

CORRECTION: I just now saw the "not". The error message actually says "hen IDENTITY_INSERT is set to OFF" The "not" through me off.

Cheers,
Brian
Post #755042
Posted Friday, July 17, 2009 4:42 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:01 AM
Points: 1,787, Visits: 5,697
sorry - posted about the comma without seeing all the other posts - dunno whats wrong with this browser of mine...

MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #755193
    Posted Friday, July 17, 2009 9:15 PM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Tuesday, August 25, 2009 6:58 PM
    Points: 4, Visits: 9
    yup
    Post #755216
    Posted Tuesday, August 25, 2009 12:03 PM


    SSC-Insane

    SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

    Group: General Forum Members
    Last Login: Friday, August 29, 2014 1:51 PM
    Points: 21,644, Visits: 15,317
    I too missed the extra comma but saw the intent of the question. Despite that, it is nice to have learned something about the extra comma in table creates.



    Jason AKA CirqueDeSQLeil
    I have given a name to my pain...
    MCM SQL Server


    SQL RNNR

    Posting Performance Based Questions - Gail Shaw
    Posting Data Etiquette - Jeff Moden
    Hidden RBAR - Jeff Moden
    VLFs and the Tran Log - Kimberly Tripp
    Post #776941
    Posted Monday, November 23, 2009 11:01 PM


    SSChasing Mays

    SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

    Group: General Forum Members
    Last Login: Friday, January 11, 2013 12:41 PM
    Points: 621, Visits: 297
    It was straight forward Q, and had a straight forward ans.



    Bhavesh Patel

    http://bhaveshgpatel.wordpress.com/
    Post #823672
    « Prev Topic | Next Topic »

    Add to briefcase ««12

    Permissions Expand / Collapse