Having troubles Commiting a user Defined Table

[lkalman@financemgr.com]

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

[james.billings]

Thanks for posting, and sorry you're running into this.

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.

[harveysburger]

I am getting the issue as well,

I see this thread is few months old, is there a patch available not for this?


thanks

[mattkarp]

We have 3 user defined table types that continuously show up as uncommitted over and over. We tried everything in terms of deleting it locally and getting it again form source, changing it locally and on the server but no matter what it continues to show up as 3 uncommitted objects.

[John Palmer]

I believe this relates to bug SOC-4068

Details in msg 15456:
http://www.red-gate.com/MessageBoard/viewtopic.php?t=15456