create proc testproc as
begin
print 'hello world'
end
2.
using System;
using System.Data;
using System.Data.SqlClient;
class TestData
{
protected static void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
foreach (SqlError err in args.Errors)
{
Console.WriteLine("The {0} has received a severity {1}, state {2} error number {3}\n" +
"on line {4} of procedure {5} on server {6}:\n{7}",
err.Source, err.Class, err.State, err.Number, err.LineNumber,
err.Procedure, err.Server, err.Message);
}
}
static void Main()
{
SqlConnection conn = new SqlConnection("server=localhost;database=tempdb;uid=sa;pwd=;");
conn.InfoMessage += new SqlInfoMessageEventHandler(OnInfoMessage);