VS for Database Pros (GDR R2) Removes Sproc Comments

[George McKee]

I have been working with my team to implement Data Dude GDR R2 for managing
ALL of the databases for our applications. So far I am very pleased by what
we can do with the tool with a single exception. I want to have a header
with comments as part of every stored procedure so we can track the history
of a procedure. When creating a deployment script, and subsequently running
it, Data Dude strips out all of the headers.

There are a number of reasons for wanting to retain the header in the
deployed code. Does anyone know if or how the comments in a sproc can be
included in the deployment script generated by the tool?

Thanks

[Dan Guzman]

You can move the comments after the first line of code in the proc (e.g.
BEGIN or SET NOCOUNT ON) in order to preserve those during deployment. See
http://blogs.msdn.com/gertd/archive/2008/12/19/handling-of-comments-in-the-gdr.aspx

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"George McKee" <olalla...@newsgroups.nospam> wrote in message
news:A9EBCA7A-7F34-42DC...@microsoft.com...