Having troubles Commiting a user Defined Table
lkalman@financemgr.com
Posts: 30
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])
)
GO
-- Permissions
GRANT EXECUTE ON TYPE:: [PR].[CalcAppointmentEarning] TO [AccountingMaster]
GO
-- 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])
)
GO
-- Permissions
GRANT EXECUTE ON TYPE:: [PR].[CalcAppointmentEarning] TO [AccountingMaster]
GO
Comments
I tested with your script here and it seems to do the same for me, so I've raised a bug (SOC-3955) for it to get looked into. Hopefully we'll get it worked out quickly for you.
Redgate Software
I see this thread is few months old, is there a patch available not for this?
thanks
Details in msg 15456:
http://www.red-gate.com/MessageBoard/viewtopic.php?t=15456