Red Gate forums :: View topic - Unsupported parsing SIGNATURE breaks source control
Return to www.red-gate.com RSS Feed Available

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

Unsupported parsing SIGNATURE breaks source control

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ashw1984



Joined: 30 Jun 2011
Posts: 2
Location: Kent, UK

PostPosted: Thu Jun 30, 2011 11:21 am    Post subject: Unsupported parsing SIGNATURE breaks source control Reply with quote

Hi All

This is a bug in the parsing engine Red Gate use. In SQL Prompt it just underlines the text red and displays an issue. But in Source Control it stop the changes being viewed thorugh Source control as i would imagine the same parsuing engine is used.

The following code parse's and executes fine in SQL but errors in source control.
1. Does anyone know if newer versions of Redgate have this fixed?
2. Does anyone know how to code around without putting the script in a string and executing the string?

ADD SIGNATURE TO OBJECT :: [Procedure]
BY CERTIFICATE [Certificate]
WITH password = 'Password';

Regards

Ash
_________________
Data Data Data
Back to top
View user's profile Send private message
ashw1984



Joined: 30 Jun 2011
Posts: 2
Location: Kent, UK

PostPosted: Thu Jun 30, 2011 11:22 am    Post subject: Fixed Reply with quote

Sorry guys i fixed it myself. here is the code round incase anyone else need it.

ADD SIGNATURE TO [Procedure]
BY CERTIFICATE [Certificate]
WITH password = 'Password';
_________________
Data Data Data
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