private string ScriptBase(Database db, string definition)
{
var before = ScriptQuotedIdAndAnsiNulls(db, false);
var after = ScriptQuotedIdAndAnsiNulls(db, true);
if (!string.IsNullOrEmpty(after))
after = Environment.NewLine + "GO" + Environment.NewLine + after;
if (RoutineType == RoutineKind.Trigger)
after +=
Environment.NewLine + string.Format("{0} TRIGGER [{1}].[{2}] ON [{3}].[{4}]", Disabled ? "DISABLE" : "ENABLE", Owner, Name,
RelatedTableSchema, RelatedTableName) + Environment.NewLine + "GO" + Environment.NewLine;
if (string.IsNullOrEmpty(definition))
definition = string.Format("/* missing definition for {0} [{1}].[{2}] */", RoutineType, Owner, Name);
return before + definition + after;
}