how to disable identity insert on a particular column RRS feed


  • Use INSERT_IDENTITY setting, you set it on when you want to insert to identity column of the table and off after that. See the documentation for more details.

    But from your question I think that you are considering case where you might have multiple identity columns, although not allowed in SQL Server, where you want to disable just one of them, is that what you are after?

    Saturday, August 31, 2013 7:48 AM