Red Gate forums :: View topic - Having troubles Commiting a user Defined Table
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Having troubles Commiting a user Defined Table

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Tue May 29, 2012 1:54 pm    Post subject: Having troubles Commiting a user Defined Table Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Thu May 31, 2012 4:36 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
harveysburger



Joined: 12 Aug 2008
Posts: 6
Location: Netherlands Antilles

PostPosted: Fri Aug 17, 2012 3:44 pm    Post subject: Get the issue as well Reply with quote

I am getting the issue as well,

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


thanks
Back to top
View user's profile Send private message
mattkarp



Joined: 01 Nov 2010
Posts: 6

PostPosted: Thu Sep 06, 2012 7:06 pm    Post subject: Commit changes over and over Reply with quote

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.
Back to top
View user's profile Send private message
John Palmer



Joined: 21 Jun 2012
Posts: 6

PostPosted: Thu Sep 06, 2012 9:14 pm    Post subject: Reply with quote

I believe this relates to bug SOC-4068

Details in msg 15456:
http://www.red-gate.com/MessageBoard/viewtopic.php?t=15456
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group