Image

Imagexterminal wrote in Imagesqlserver

Listens: Porcupine Tree, "Wedding Nails"

SET IDENTITY_INSERT on an in-memory table?

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.