private string ChangeSqlTypeTo(string sql, string type)
{
int index = sql.IndexOf(' ');
string startingCommand = sql.Substring(0, index).ToUpperInvariant();
if (startingCommand != "CREATE" && startingCommand != "ALTER")
throw new Exception(Resources.UnableToExecuteProcScript);
return type + sql.Substring(index);
}