USE [Gaz_station]
GO
/****** Object:  Trigger [dbo].[Reports_message]    Script Date: 13.03.2015 13:48:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Reports_message]
ON [dbo].[Reports]
FOR INSERT
AS
PRINT 'Был создан новый отчет.'
RETURN 

        private static void OpenSqlConnection()
        {
            string connectionString = GetConnectionString();

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                Console.WriteLine("State: {0}", connection.State);
                Console.WriteLine("ConnectionString: {0}",
                    connection.ConnectionString);
            }
        }

        static private string GetConnectionString()
        {
            return "Data source=ALPHA-PC;Initial Catalog=Gaz_station;Integrated Security=True;";
        }

        protected static void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
        {
            foreach (SqlError err in args.Errors)
            {
                MessageBox.Show(err.Message, "Состояние", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

            }
        }

connection.InfoMessage += new SqlInfoMessageEventHandler(OnInfoMessage);