I have more or less borrowed the code that is supposed to make this possible, but it isn't working. I appaer to by misusing the SQLconnection class. I've done this before in vb but obviously c# is a little different. Here is the code I am currently trying to use.
Any help pointing me toward the right direction woudl be appreciated.
public class tat_io_trigger
public static void Main()
SqlTriggerContext triggContext = SqlContext.TriggerContext;
Sqlconnection conn = new SqlConnection ("context connection = true");
SqlCommand sqlComm = conn.CreateCommand();
SqlPipe sqlP = SqlContext.Pipe;
sqlComm.CommandText = "Exec sp_gettatdata";