try
            {
                if (connection.State != ConnectionState.Open) connection.Open();

                var cmd = connection.CreateCommand();
                cmd.CommandTimeout = cfg.CmdTimeout;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "dbo.test";

                var ParamReturn = cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int);
                ParamReturn.Direction = ParameterDirection.ReturnValue;
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Test");
            }

CREATE PROCEDURE test
AS
BEGIN
	SET NOCOUNT ON;
	RAISERROR(N'Kuku1',0,0) WITH NOWAIT
	select @@VERSION as '@@VERSION'
	RAISERROR(N'Kuku2',0,0) WITH NOWAIT
	select @@LANGID as '@@LANGID'
	RAISERROR(N'Pisec',0,0) WITH NOWAIT
	return @@CONNECTIONS
END
GO