IT'S OK

Simplest method is restore:

CREATE DATABASE SNASPHOT

EXECUTE Migration TSQL Scripts
-

IF ERROR 

RESTORE FROM SNASPHOT DB

• This reply was modified 17 hours, 21 minutes ago by Bogdan.
• This reply was modified 17 hours, 20 minutes ago by Bogdan.

GO go | IT'S Ok

CREATE a TSQL script used to create/generate a TSQL thus:

SELECT OPENDATASOURCE

UNION ALL

SELECT OPENDATASOURCE

UNION ALL

SELECT OPENDATASOURCE

ETC?

IT's OK

It'S OK

Optimization

IT's Ok

I teeling you litttle secret:

SET XACT_ABORT ON

BEGIN TRANSACTION <-- THIS CREATE A TRANSACTION

etc ETC TSQL Scripts

Is simple , much simple

• This reply was modified 5 days, 17 hours ago by Bogdan.

IT'S Ok

ATN2 BUNA, DIN NOU

First thank you very much. Sory, no performance tests today.