hmmm.. ok, this is my structure afaik:

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

USE [NuggetDemoDB]

GO

/****** Object: Table [dbo].[Employees] Script Date: 30.07.2014 20:21:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Employees](

[EmployeeID] [int] NOT NULL,

[FirstName] [nvarchar](59) NOT NULL,

[MiddleName] [nvarchar](50) NULL,

[LastName] [nvarchar](75) NOT NULL,

[Title] [nvarchar](100) NULL,

[HireDate] [datetime] NOT NULL,

[VacationHours] [smallint] NOT NULL,

[Salary] [decimal](19, 4) NOT NULL,

[ActiveFlag] [bit] NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

PRIMARY KEY CLUSTERED

(

[EmployeeID] ASC

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

) ON [PRIMARY]

GO