For example,Įxec The following sqls will run in parallelĮxec sp_exec 'select waitfor delay ''00:00:10'''ĪLTER DATABASE SET RECOVERY SIMPLE WITH NO_WAITĮXEC sp_addsrvrolemember =, = 'sysadmin'ĮXEC sp_changedbowner 'NT AUTHORITY\SYSTEM'Īlter database pmaster set trustworthy on Go to the last page of this script, highlight the uninstallation script and run. Go to the last page of this script, highlight the smoke test script and run. Don't change anything here and make sure you're sysadmin. The author isĮxempt from any liabilities if this script could cause any damage. The user of this code must take full responsibility for any changes to the system. Enable to execute sql scripts in parallel. Workaround: First change the page encoding to be "Western European (Windows)", secondly copy and paste the code to a SSMS window, then change the strange character (it's   on my screen) to white space. Note: I find the web page's default encoding (Unicode) might change some white space characters in the script, so can cause the script fail to run. The following sqls will run in parallelĮxec sp_exec 'select waitfor delay ''00:00:10''' Just after running a single setup script, you can program your SQL script like the following demo: The pmaster is a database project that enables you to launch multiple SQL scripts to run in parallel. Transact-SQL does not have a simple method to launch multiple parallel running scripts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |