private void ExecuteSQL(String dbName, String sql) { var connection = new SqlConnection(@"Data Source=Localhost\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"); var sqlCommand = new SqlCommand(sql, connection); String[] commands = sql.Split(new string[] { "\nGO" }, StringSplitOptions.RemoveEmptyEntries); sqlCommand.Connection.Open(); sqlCommand.Connection.ChangeDatabase(dbName); var curr = String.Empty; try { foreach (String cmd in commands) { curr = cmd; sqlCommand.CommandText = cmd; sqlCommand.ExecuteNonQuery(); } } catch (Exception) { var form = new LogShow("Error at: " + curr); form.ShowDialog(); throw; } finally { sqlCommand.Connection.Close(); } }