using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Threading;

namespace Sample
{
	public class Sample
	{
		private static ArrayList InfoMessages = new ArrayList();

		[STAThread]
		public static void Main(string[] args)
		{
			SqlConnection connection = new SqlConnection("Server=LOCALHOST;Database=master;Integrated Security=SSPI;");
			SqlCommand command = new SqlCommand("PRINT 'hello ' + CURRENT_USER;PRINT 'my name is ' + DB_NAME();PRINT 'goodbye ' + CURRENT_USER;", connection);

			connection.InfoMessage += new SqlInfoMessageEventHandler(OnInfoMessage);

			connection.Open();
			command.ExecuteNonQuery();
			connection.Close();

			foreach (string message in InfoMessages)
			{
				Console.Out.WriteLine(message);
			}

			Thread.Sleep(2000);
		}

		private static void OnInfoMessage(object sender, SqlInfoMessageEventArgs e)
		{
			InfoMessages.Add(e.Message);
		}
	}
}