I recently received one big file with many T-SQL batches. It was very big file and I was asked that this file was tested many times and it can run one transaction. I noticed the separator of the batches is not GO but it was EndBatch. I have following two options to run the whole batch in one transation.
1) Mass replace EndBatch with GO.
Only problem I had with is that if EndBatch word was used in other place then batch separator it will replace there too. I searched and noticed that it was used in name of the Stored Procedure. I finally came up with second method which worked fine.
2) Change the batch separator.
Go to Tools >> Options >> Change the Batch Separator to EndBatch from GO.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Additional Read about GO operator: SQL SERVER – Explanation SQL Command GO
