Search code examples
sql-server

How to run sql script using SQL Server Management Studio?

I have been following this tutorial: http://www.misfitgeek.com/2010/07/adding-asp-net-membership-to-your-own-database/

I have installed SQL Server Management Studio Express from here: http://www.microsoft.com/download/en/details.aspx?id=8961.

1) How can I locate my database?

2) How do I run the SQL script on my database from external file?

Solution

  • This website has a concise tutorial on how to use SQL Server Management Studio. As you will see you can open a "Query Window", paste your script and run it. It does not allow you to execute scripts by using the file path. However, you can do this easily by using the command line (cmd.exe):

    sqlcmd -S .\SQLExpress -i SqlScript.sql

    Where SqlScript.sql is the script file name located at the current directory. See this Microsoft page for more examples