Having troubles Commiting a user Defined Table

lkalman@financemgr.com[email protected] Posts: 30
edited September 6, 2012 4:14PM in SQL Source Control Previous Versions
Issues cant commit User Defined Type Table. It goes thru as it normally does but stills shows as a un commited change

-- User Defined Type

CREATE TYPE [PR].[CalcAppointmentEarning] AS TABLE
[AppointmentEarningID] [int] NOT NULL,
[AppointmentID] [int] NOT NULL,
[EarningID] [int] NOT NULL,
[Entitlement] [decimal] (18, 2) NULL,
[PeriodPay] [decimal] (18, 2) NULL,
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[IncludeInPeriodPayFlag] [bit] NULL,
[DeletedFlag] [bit] NOT NULL DEFAULT ((0)),
PRIMARY KEY CLUSTERED ([AppointmentEarningID])
-- Permissions

GRANT EXECUTE ON TYPE:: [PR].[CalcAppointmentEarning] TO [AccountingMaster]


Sign In or Register to comment.