Running scripts in SQL Server Management Studio

From EHS Help
Revision as of 10:14, 20 April 2016 by Admin (Talk | contribs)

Jump to: navigation, search

_NOTOC__

This is a Technical (IT) Instructions topic


Running Scripts from Files

Instructions here are specifically for the IBID Training Centre in Wythenshawe, but the principles apply to any installation.

  • Start remote desktop and login to UHSM-IBID2.
  • Start MS SQL Server Management Studio
  • Select File > Open > File from the menu (or press CTRL + O) (or press the Open button on the toolbar)
  • In the Open File window, pick the .sql file and press Open
  • On the Toolbar, ensure that the database drop down list is showing the name of the database you want the script to act upon.
  • Press Execute on the toolbar.


Running Scripts via copy & paste

  • Start remote desktop and login to UHSM-IBID2.
  • Start MS SQL Server Management Studio
  • Copy the SQL script to the clipboard from another program, e.g. the web - being careful to include all characters.
  • Press the New Query button on the toolbar.
  • Paste the SQL into the query window by pressing CTRL + V (or selecting Edit > Paste from the menu)
  • On the Toolbar, ensure that the database drop down list is showing the name of the database you want the script to act upon.
  • Press Execute on the toolbar.
Retrieved from ‘https://evolutionhealthcaresystems.co.uk/help/index.php?title=Running_scripts_in_SQL_Server_Management_Studio&oldid=4395’