Red Gate forums :: View topic - Error trying to apply updates to Trigger from TFS to DB
Return to www.red-gate.com RSS Feed Available

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

Error trying to apply updates to Trigger from TFS to DB

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
ajkauffman



Joined: 26 Apr 2010
Posts: 4

PostPosted: Mon Apr 26, 2010 8:27 pm    Post subject: Error trying to apply updates to Trigger from TFS to DB Reply with quote

I was testing the capabilities of synchronizing Table changes, specifically a Trigger. I made a change outside of SSMS to the table's script file that contained the trigger being changed and then checked it into TFS. In SSMS it saw the change and after I attempted to apply it to my local DB, it generated an error at the "Registering Selected Changes" step. I don't have the exact syntax because it did not allow me to copy it, but it was something close to this:

Errors occured whilst parsing file "C:\Red Gate\SQL Source Control 0\workingBases\dfjkdsfjklsdljksdfjlkdsf\Tables\dbo.Customer.sql
'Line 447:1 expecting "conversation", found 'GO

Not sure what is meant by "conversation". The same script parses just fine in SSMS.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Tue Apr 27, 2010 7:35 pm    Post subject: Reply with quote

Thanks for your post.

Could you make sure you're on the latest version of SQL Source Control? (Help > Check for updates)

Can you also send the file 'C:\Red Gate\SQL Source Control 0\workingBases\dfjkdsfjklsdljksdfjlkdsf\Tables\dbo.Customer.sql' to SQLSourceControlSupport@red-gate.com? We should then be able to recreate the problem here and hopefully provide a fix.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
ajkauffman



Joined: 26 Apr 2010
Posts: 4

PostPosted: Wed May 05, 2010 7:05 pm    Post subject: Reply with quote

I verified that I am using the latest version and I emailed the file you requested. Thanks for the response.
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Fri May 14, 2010 10:47 am    Post subject: Error trying to apply updates to Trigger from TFS to DB Reply with quote

Thank you for emailing the files. We are looking into this now. Our internal reference number is SOC-1020.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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