Suspend SQL server script?

Question

I am trying to develop a script that I can run based on SQL Server 2008 [Express]. The database contains about 10-15 tables, which are updated with different values ​​/ new fields, etc.

However, this is not a fully automated process and at update points, it would be great to suspend script execution, put the mailbox out of the script, which allows the user to do it <something>. Clicking OK on the script will continue execution and complete the migration.

Is there such a thing?

Answer 1

T-SQL script . WAITFOR , .

A () , script -chunks BATCH script. : -

SQLCMD -S <servername> -E -I <path_to_script_one>
PAUSE
SQLCMD -S <servername> -E -I <path_to_script_two>

, ; , . BATCH , script .

, , SQL.

"" , , ...

Answer 2

WAITFOR. , T-SQL script

Answer 3

SQL Server .

SQL 2008 Management Studio script , , script .

script undefined , , script.

If you want this to be automated, you could then run them from a .cmd file using the DOS PAUSE command between scripts.