Skip to content

Instantly share code, notes, and snippets.

@camous
Last active May 10, 2017 12:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save camous/e8eb5edac13a08b65fb4cf52a3078d15 to your computer and use it in GitHub Desktop.
Save camous/e8eb5edac13a08b65fb4cf52a3078d15 to your computer and use it in GitHub Desktop.
alter existing stored procedure produced by TableDependency for supporting "replay"
class Program
{
static void Main(string[] args)
{
using (var con = new SqlConnection(Properties.Settings.Default.ConnectionString))
{
con.Open();
var serverConnection = new ServerConnection(con);
var server = new Server(serverConnection);
foreach (Trigger trigger in server.Databases["DATABASE"].Tables["Employee", "HumanResources"].Triggers)
{
Trace.TraceInformation("alter trigger " + trigger.Name + " created on " + trigger.CreateDate);
var noexceptbody = Regex.Replace(trigger.TextBody, @"EXCEPT (.*) \[m_Old\]", String.Empty);
trigger.TextBody = noexceptbody;
trigger.TextMode = false;
trigger.Alter();
}
con.Close();
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment