I was just testing it out with really simple inserts.

USE TMS
GO

SET IDENTITY_INSERT dbo.Objects ON

INSERT INTO dbo.Objects (ObjectID, ObjectNumber, SortNumber, 
ObjectStatusID, DepartmentID, ClassificationID, LoginID)

VALUES ('33094', 'ht0005191', 'ht 000519 1', 9, 3, 'tmsuser')

SET IDENTITY_INSERT dbo.Objects OFF

GO

--------------------------

USE TMS
GO

SET IDENTITY_INSERT dbo.ObjTitles ON

INSERT INTO dbo.ObjTitles (TitleID, ObjectID, TitleTypeID, Title, Remarks, 
Active, LoginID, DisplayOrder, Displayed, LanguageID)
VALUES ('37857', '33094', 2, 'Barnum & Bailey: Managers', NULL, 1, 'tmsuser', 
1, 1, 1)

SET IDENTITY_INSERT dbo.ObjTitles OFF

GO

---------------------------

USE TMS
GO

SET IDENTITY_INSERT dbo.Constituents ON

INSERT INTO dbo.Constituents (ConstituentID, ConstituentTypeID, Active, 
AlphaSort, LastName, FirstName, Institution, DisplayName, LoginID, 
PublicAccess)  

VALUES ('6391', 1, 1, 'Unknown', 'Unknown', NULL, 
NULL, 'Unknown', 'tmsuser', 'True')

SET IDENTITY_INSERT dbo.Constituents OFF

GO

---------------------------

USE TMS
GO

SET IDENTITY_INSERT dbo.ConXrefs ON

INSERT INTO dbo.ConXrefs (ConXrefID, ID, ConstituentID, RoleID, TableID, 
LoginID, DisplayOrder, Displayed, Active, RoleTypeID)

VALUES ('65890', '33094', '6391', '1', '108', 'tmsuser', 1, 1, 1, 2)

SET IDENTITY_INSERT dbo.ConXrefs OFF

GO