• I don't have code for creating the database. As I indicated previously, I didn't create the thing, I just get stuck cleaning it up when the end user does something unforeseen.

    This is code from a backup script, but it assumes the database already exists and is working with individual tables. When I try to use it to create a table, it runs with no errors, but I can't find the table anywhere.

    SET ANSI_NULLS ON

    SET QUOTED_IDENTIFIER ON

    IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Archives]') AND type in (N'U'))

    BEGIN

    CREATE TABLE [Archives](

    [ArchiveID] [int] IDENTITY(1,1) NOT NULL,

    [StartDate] [datetime] NOT NULL,

    [EndDate] [datetime] NOT NULL,

    CONSTRAINT [PK_Archives] PRIMARY KEY CLUSTERED

    (

    [ArchiveID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]

    END

    SET IDENTITY_INSERT[Archives] ON

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (1, CAST(0x0000A08800000000 AS DateTime), CAST(0x0000A08E00000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (2, CAST(0x0000A08F00000000 AS DateTime), CAST(0x0000A09500000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (3, CAST(0x0000A09600000000 AS DateTime), CAST(0x0000A09C00000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (4, CAST(0x0000A09D00000000 AS DateTime), CAST(0x0000A0A300000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (5, CAST(0x0000A0A400000000 AS DateTime), CAST(0x0000A0AA00000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (6, CAST(0x0000A0AB00000000 AS DateTime), CAST(0x0000A0B100000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (7, CAST(0x0000A0B200000000 AS DateTime), CAST(0x0000A0B800000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (8, CAST(0x0000A0B900000000 AS DateTime), CAST(0x0000A0BF00000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (9, CAST(0x0000A0C000000000 AS DateTime), CAST(0x0000A0C600000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (10, CAST(0x0000A0C700000000 AS DateTime), CAST(0x0000A0CD00000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (11, CAST(0x0000A0CE00000000 AS DateTime), CAST(0x0000A0D400000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (12, CAST(0x0000A0D500000000 AS DateTime), CAST(0x0000A0DB00000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (13, CAST(0x0000A0DC00000000 AS DateTime), CAST(0x0000A0E200000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (14, CAST(0x0000A0E300000000 AS DateTime), CAST(0x0000A0E900000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (15, CAST(0x0000A0EA00000000 AS DateTime), CAST(0x0000A0F000000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (16, CAST(0x0000A0F100000000 AS DateTime), CAST(0x0000A0F700000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (17, CAST(0x0000A0F800000000 AS DateTime), CAST(0x0000A0FE00000000 AS DateTime))

    INSERT[Archives] ([ArchiveID], [StartDate], [EndDate]) VALUES (18, CAST(0x0000A0FF00000000 AS DateTime), CAST(0x0000A10500000000 AS DateTime))

    SET IDENTITY_INSERT[Archives] OFF