sql server programming: Hi All,

I have written an batch file that is use to take a backup
of the existing procedure from the database and stores in
the undo\sprocs\ directory.

Code:

FOR /F %%1 IN (runsprocs) DO IF NOT EXIST ..\Undo\sprocs\%
%1.sql ECHO Undo\sprocs\%%1...>> %LOG% && ECHO
Undo\sprocs\%%1... && OSQL -S myserver -U sa -P sa -d
mydatabase -l 300 -b -n -h-1 -w300 -Q"PRINT 'IF EXISTS
(SELECT * FROM sysobjects WHERE type=''P'' AND name=''%%
1'') DROP PROC %%1 ' + CHAR(13) + CHAR(10) + 'GO' IF
EXISTS (SELECT * FROM sysobjects WHERE type='P' AND
name='%%1') EXEC sp_helptext %%1" -o ..\Undo\sprocs\%%
1.sql >> %LOG% & IF ERRORLEVEL 1 GOTO INSTALL_ERROR


Problem:

In here runsprocs.sql is a file it contains the list of
stored procedures.

Example:
sptest

It is working fine. But the problem is when it creates a
sql file in the undo directory the sql file contains
extra line breaks ?

How can i avoid the extra line breaks ? Can anyone help
me?

With Regards,

Hi,

Expected Result:

IF EXISTS (SELECT * FROM sysobjects WHERE type='P' AND
name='sptest') DROP PROC sptest
GO

CREATE PROCEDURE sptest
AS

/*********************************************************
**************************
**
** Name: sptest.sql
**
** Description: This procedure is the Transaction for
Contract payment
** type.


Actual Result:

IF EXISTS (SELECT * FROM sysobjects WHERE type='P' AND
name='sptest') DROP PROC sptest
GO






CREATE PROCEDURE sptest




AS











/********************************************************
***************************



**





** Name: sptest.sql




**





** Description: This procedure is the Transaction for
Contract payment



** type.


In the actual result you can find lots of line breaks.
How can i avoid these extra line breaks/ empty spaces ?

With Regards,
Anand


[quoted text, click to view]