I found the link you referred to in your other message in googling around, but I think i may be asking the wrong question or expecting something of tsql it doesn't now how to do :

I want to put TSQL in a script that is now sending PRINT statements to the message window that will, instead, send them to a specifically named file. Can I invoke the sqlcmd line utility from within a TSQL script I am running in SSMS?

Obviously you know how we'd do this in fox with a textmerge and I know how i'd do it in VB or C#.

I have this script, for example :

DECLARE @indexName VARCHAR(128)
DECLARE @tableName VARCHAR(128)

DECLARE [indexes] CURSOR FOR
	
	SELECT	[sysindexes].[name] AS [Index],
			[sysobjects].[name] AS [Table]
	
	FROM	[sysindexes]
	
	INNER JOIN	[sysobjects]
	               ON	[sysindexes].[id] = [sysobjects].[id]
	
	WHERE	[sysindexes].[name] IS NOT NULL
	AND		[sysobjects].[type] = 'U'

OPEN [indexes]

FETCH NEXT FROM [indexes] INTO @indexName, @tableName

WHILE @@FETCH_STATUS = 0
BEGIN 

        PRINT 'DROP INDEX [' + @indexName + '] ON [' + @tableName + ']'

	FETCH NEXT FROM [indexes] INTO @indexName, @tableName
END

CLOSE		[indexes]
DEALLOCATE	[indexes]

I want to tell it that everything in PRINT should PRINT TO FILE DropIndexes.sql

Is that possible in T-SQL?

And if it is, is there a T-SQL command that will then execute DropIndexes.sql ?




>The SqlCmd command line utility may work for you
>
>

>SqlCmd -S ServerName  -i "Input Script name" -o "Output script name" 
>

>
>>I have four scripts that use metadata and PRINT commands to create scripts that perform alterations on a database schema and data.
>>
>>Currently the output is going to a message window, i am cutting and pasting into a new query and running the result.
>>
>>I would like to have each "creation" script put its output into a new script.
>>
>>The goal is to consolidate the four "creation" scripts into one, and have each of the four batches within that script create its own .sql file ( the name and location would remain fixed with automatic overwrite ) and then to run those four scripts in sequence.
>>
>>I see that I can point the results of a query to file rather than the message window but don't see how to do that programmatically in T-SQL
>>
>>As always, guidance appreciated.