If I highlight/select both the statements below, without a GO stmt between them, will the Insert be committed once it shows 'Rows Affected 1234' in results pane?
If so, can I then cancel the Rebuild proc without rolling back the Insert?

```
Insert into tablexx
Exec RebuildDisableIndexes,'Rebuild', tablexx

```

These are the results so far:

```none
(2000000) rows affected;
2 of 7 indexes have been rebuilt by the proc RebuildDisableIndexes (alter index...Rebuild step 2 of 7).

```

But something is bogging step 3 down.

If I cancel the query will it roll back the insert of 2000000 rows? I don't think it will, but seeking confirmation.