?
Solved

comments in sql server stored procs using SVN

Posted on 2009-05-13
1
Medium Priority
?
372 Views
Last Modified: 2013-11-25
Hi folks. I'm trying to move our team from VSS to SVN, so far so good, but a small issue came up. In our sql sprocs when we used VSS we added the following comments

-- =============================================
-- $Archive: <path>$
-- $Revision: <revision #> $
-- $Date: <date> $
-- $Author: <author> $
-- =============================================

where the items between angle brackets were populated by VSS and the script file would have the information after every check in. This helped us track sql sprocs when we went from dev to prod. Is there a way to do this in SVN? a hook of some sort or built in functionality that anyone knows of?  Any and all help is appreciated.

Thanks
Z
0
Comment
Question by:zaidmarji
1 Comment
 
LVL 25

Accepted Solution

by:
reb73 earned 1000 total points
ID: 24377697
I think you have to enable keyword substitution on SVN..

See link below to see if it helps -

http://svnbook.red-bean.com/en/1.5/svn-book.html#svn.advanced.props.special.keywords
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question