SQL CLR如何访问安全模式下运行的用户名、主机名和app_名称

你可以使用 context connection 并执行必要的TSQL来检索所需的值。

在CLR触发器定义中:

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Context Connection=true";

SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;

cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT suser_name() as suser_name, host_name() as host_name, APP_NAME() as app_name";

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