English

English EN 日本語 JA 한국어 KO Português PT Español ES Deutsch DE Русский RU Français FR 繁體中文 ZH-TW 简体中文 ZH-CN

((hot)) - Ssis 864

using (SqlCommand cmd = new SqlCommand(sql, conn))

In the stored procedure, use local variables or OPTION (RECOMPILE) :

cmd.CommandTimeout = 300; // seconds cmd.ExecuteNonQuery();

using (SqlCommand cmd = new SqlCommand(sql, conn))

In the stored procedure, use local variables or OPTION (RECOMPILE) :

cmd.CommandTimeout = 300; // seconds cmd.ExecuteNonQuery();