Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

Randy McFarland

Member since Dec 5, 2012

Recent Blog Comments By Randy McFarland

  • Turning Off and On Identity Column in SQL Server

    Posted on Dec 5, 2012 at 8:19 AM

    I have used the SET IDENTITY_INSERT feature several times when migrating data, but have always done so in an "off-line" mode. Can this feature be used while the database is online taking other requests? In other words, will the setting of IDENTITY_INSERT to ON affect only my specific ses... read more »