Unsupported parsing SIGNATURE breaks source control

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Unsupported parsing SIGNATURE breaks source control

Postby ashw1984 » Thu Jun 30, 2011 11:21 am

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
ashw1984
 
Posts: 2
Joined: Thu Jun 30, 2011 11:11 am
Location: Kent, UK

Fixed

Postby ashw1984 » Thu Jun 30, 2011 11:22 am

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
ashw1984
 
Posts: 2
Joined: Thu Jun 30, 2011 11:11 am
Location: Kent, UK


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests