using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public class RaisingInfoMessage
{
public static SqlConnection con;

public static void Main()
{
con = new SqlConnection(
ConfigurationSettings.AppSettings["constring"]
);

con.InfoMessage +=
new SqlInfoMessageEventHandler(InfoMessage);

SqlCommand cmd = new SqlCommand("PRINT 'This is a test'", con);

con.Open();
SqlDataReader reader = cmd.ExecuteReader();

while(reader.Read())
{
Console.WriteLine("{0} - {1}",
reader.GetString(0),
reader.GetString(1));
}

con.Close();

Console.ReadLine();

}

public static void InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
for(int i=0; i < e.Errors.Count; i++)
{
Console.WriteLine("{0} - {1}",
"InfoMessage",
e.Errors[0].ToString());
}
}
}