Home Forums SQL Server 2005 T-SQL (SS2K5) Does/can OUTPUT clause turn identity_insert on & off RE: Does/can OUTPUT clause turn identity_insert on & off

  • Actually, the BoL states, that you shouldn't include identity columns in the column list of output_table, so reported behaviour is the bug (or free feature, if you like :hehe:).

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]