How can we help you today? How can we help you today?

Having troubles Commiting a user Defined Table

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
lkalman
0

Comments

4 comments

Sort by
  • James B
    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.
    James B
    0
  • 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
    harveysburger
    0
  • 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.
    mattkarp
    0
  • John Palmer
    I believe this relates to bug SOC-4068

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

Add comment

Please sign in to leave a comment.