How to replay an SQL script (SQL Profiler)
To replay an SQL script
- On the File menu, point to Open, and then click SQL Script.
- Select the Transact-SQL script file to open.
- On the Replay menu, click Start.
- In the Connect to SQL Server dialog box, select the server to connect to and a connection method.
- In the Replay SQL Server dialog box, alter any necessary settings, and then click Start.