How do I run a DDL-SQL to create tables on a newly created database in Visual Web Developer 2010?
New to the ASP.NET world, I'm trying to insert the ddl to build the Northwind database.
I've tried the trick of inserting the SQL from a query-view, but SQL Server Express Edition crashes :-)
(Hello Microsoft, long time, no see...)
You can download MS SQL Server Management Studio Express (it's free). With this tool managing SQL Server databases is a lot easier.
Edit (answer to the comment below),
It doesn't work that way :) SQL Server has two authentication methods: Windows authentication and its own (user and password). First you need to use Windows authentication to log in and you can do whatever you want, for example change the sa (server administrator) password.