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
|