I have an SQL script than runs a couple of DBBC commands. Is there a way to send the messages generated from executing these commands to a simple log file e.g "C:\log.txt"?

The messages I mean are the ones that appear in the messages box at the bottom of SQL Server 2005 Management Studio after a query has executed.

The reason for needing to do this is because I don't intend on having SQL Server Management Studio open so the messages can't be seen.

I am using SQL Server 2005 if that helps.

+3  A: 

You can run scripts from the Command line using SQLCMD utility.

You can run this through a batch file. It let's you log to a file.

You can automate such jobs using scheduling programs.

Raj More
Just what I was looking for. Thank you!
+3  A: 

In SSMS, click Query->Results To...->Results To File

Mitch Wheat