Running sql scripts against an attached database?

Posted by Will on Stack Overflow See other posts from Stack Overflow or by Will
Published on 2010-01-16T22:01:53Z Indexed on 2010/04/16 23:03 UTC
Read the original article Hit count: 158

Filed under:

mdf

|

sql-server-express

|

sql

|

query

I've got an MDF attached to an instance of Sql Server 2008 Express, and I need to run some sql scripts against it to generate tables, indexes, etc.

But I can't figure out how to get this to work. If I load the scripts in Visual Studio, it only allows me to connect to the server and run it against a database. I can't choose a different provider (Microsoft Sql Server Database File), so I can't select my MDF.

This leaves me the only option of running the script as individual queries, but that won't work as it appears it doesn't support TSQL CREATE statements.

How can I run my sql script against an attached database?

© Stack Overflow or respective owner

Related posts about mdf

Convert SQLExpress 2005 .mdf to 2008 .mdf ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have a Visual Studio solution and an ASP.NET MVC project that uses an mdf sql express 2005 database file in the App_Data. I want to know how I can upgrade this file so it works for sql express 2008 ? Thanks >>> More
Problem with importing an mdf created with SQL Server Express 2008 into SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
The question is probably extremely easy to resolve, but I need to resolve it because I need to carry on with my project. I am using SQL Server Express 2008 at home, and I've been working on an ASP.NET MVC app that stores my DB in an mdf file in the project's folder. The problem is that the SQL Server… >>> More
Copy mdf file and use it in run time

as seen on Stack Overflow - Search for 'Stack Overflow'
After I copy mdf file (and his log file) I tries to Insert data. I receive the following message: "An attempt to attach an auto-named database for file [fileName].mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. When I copied the… >>> More
how to use an mdf in App_Data with shared hosting

as seen on Stack Overflow - Search for 'Stack Overflow'
If I create a website that uses an mdf in App_Data with the connection string: Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname; Trusted_Connection=Yes; what do I need to do to run the site in a shared hosting environment? Do I need to copy the contents of my… >>> More
Membership in ASP.Net applications - part 3

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This is the third post in a series of posts regarding ASP.Net built in membership functionality,providers,controls. You can read the first one post one here . You can read the second post here . In this post I would like to investigate how to use the Membership class methods to achieve the same functionality… >>> More

Related posts about sql-server-express

SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.

as seen on SQL Authority - Search for 'SQL Authority'
Recently I had faced very interesting situation. Due to some reason we were not able to login into the production server for one of client. The reason for the same was that server was very busy, we had to login into the system and bring server to normal situation. When all the attempts failed, I decided… >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
Problem with importing an mdf created with SQL Server Express 2008 into SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
The question is probably extremely easy to resolve, but I need to resolve it because I need to carry on with my project. I am using SQL Server Express 2008 at home, and I've been working on an ASP.NET MVC app that stores my DB in an mdf file in the project's folder. The problem is that the SQL Server… >>> More
Scheduling Jobs in SQL Server Express - Part 2

as seen on SQL Team - Search for 'SQL Team'
In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based… >>> More
Scheduling Jobs in SQL Server Express

as seen on SQL Team - Search for 'SQL Team'
As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed… >>> More