to remove comments from sp - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

to remove comments from sp

Author

Topic

mahender
Starting Member

12 Posts

Posted - 2010-06-30 : 07:06:25

how to remove comments from a stored procedure ??? pls hlp me out
comments may be like /****/ or --abcd

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-30 : 07:13:29

Do you want to do it for many procedures?

Madhivanan

Failing to plan is Planning to fail

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-06-30 : 09:43:48

Why do you want to do that?

--
Gail Shaw
SQL Server MVP

X002548
Not Just a Number

15586 Posts

Posted - 2010-06-30 : 10:22:02

edit your PVCS entry, check it out, remove the comments recompile and check it back in to PVCS and release it to QA

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

mahender
Starting Member

12 Posts

Posted - 2010-07-01 : 02:45:13

I have a task to remove the comments from Sps .. i have 800 of them.... but i finished it manually ... thk guys .. tc

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources