Date: 08/28/07 (SQL Server)    Keywords: sql, web

I'm 98% sure this can be done, but I'm not finding anything on the web that explicitly says yes or no, and I want to rule out the possibility that I'm just banging my head against a wall. T-SQL, SQL Server 2005.

Can SET IDENTITY_INSERT be used on an in-memory table? e.g.,

DECLARE @m_tblOpenReceipts TABLE (
ID INT IDENTITY (1,1), (etc.)
}

...

SET IDENTITY_INSERT @m_tblOpenReceipts ON

Thanks.

Source: http://community.livejournal.com/sqlserver/63141.html