how can i see data in mdf file.
i have asp.net application. it has App_Data folder. this folder contain mdf and ldf file. how can i see data within these file. i want to see table structure. ...
mdf
How can I generate the SQL CREATE TABLE statement for an MDF table?
I have an .mdf file with Visual Studio 2008 with one table in it that has numerous columns of various types. How can I generate the SQL statement that produces this table so that I can alter it and create another similar table? Is there a way to do this without SQL Server? ...
Copy mdf file and use it in run time
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 file manual everything worked normally....
How do I copy a DB from the server to the application's AppData folder?
Hello folks, I've been working on an ASP.NET application accessing a DB in my local machine. Now I want to have this DB in the app's AppData folder instead, so I can easily work on it from within VS SQL instance accessing the mdf file, and easily copy and share it between programmers. Thanks a lot! ...
mdf file is work correctly under App_data folder but after attaching to sql server give following error
mdf file is working correctly under App_data folder but after attaching it to sql server give following error when running asp.net page. Cannot open user default database. Login failed. Login failed for user 'Domain\myUserName'. [edit] More information; SQL data source and connection string. <asp:SqlDataSource id="srcFiles" ...
Connecting to sql server database mdf file without installing sql server on client machine ?
I am creating a window application that need to use sql server database. I want to install this application to client machine without installing sql server so that my application can still connect to a database i.e mdf file that i will be providing at client system. How can i connect to a database(mdf) on client machine through my win...
Running sql scripts against an attached database?
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...
MDF (SQL) database file is over 88 GB and i have no idea why!
hi, With some reason my sql database file exploded to become over 88 GB and i can't see a reason why. i run few scripts to search for large tables, found nothing to be too big. i also tried to run shrink database (which did nothing) and shrink files (which return an error). has anyone has any idea what else i can do? Thanks. ...
How to query from log files (.ldf) of Sql Server 2005 Express edition?
I want to do this, because I would like to know how many times a particular row has been changed. Is this possible? Thanks ...
beginning: sql server 2008 express with mdf file
i want to practice connecting from asp.net to a sql server database. i have it in mdf file. please help me. what is the next step? i got the sample mdf database from here: http://msftdbprodsamples.codeplex.com/releases/view/37109 ...
not connecting because read-only (sql server, mdf file)
this is a different question concerning: http://stackoverflow.com/questions/2360433/add-a-connection-to-database-not-working-asp-net-to-mdf i am unable to connect because of the noted error message the database must be read only? but when i click the properties of the file read only is not checked is there another way it could be rea...
aspnet_regsql not working at all
I would like to create the ASP.NET User database template on a database of my own, because I'd like to fully untegrate the user system with the rest of my DB. As I've read, i needed to use the aspnet_regsql tool. I put all the options (because my database is running on SQLEXPRESS and is in an mdf file in my project's folder). the program...
Problem with importing an mdf created with SQL Server Express 2008 into SQL Server 2005
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 in the Uni labs is SQL Server 2005, a...
Setting up a SQL Membership Provider and attaching the MDF file in Visual Studio 2008
I'm trying to set up a SQL Membership Provider for an ASP.NET MVC 1.0 and I'm having problems setting up the tables and stored procedures in the database. I've tried attaching both the applications current database and a blank database to my local SQLEXPRESS instance (using SSEUtil) and then running the aspnet_regsql wizard against them...
How to automatically check out a database file in a source controlled web application ?
Hello, I am working on an ASP.NET web application, we are a small team (4 students) and we do not have access to a dedicated server to host the database instance. So for this web application we decided just to put the database file in the App_Data folder. The problem is that our project is source controled on TFS, so every time you ope...
Not able to add column value
I have project which contain 4 tables among these shedule table Session column i am not able to add vaue,,this table contain three foriegn key from two tables(in which single table has two foreign keys here) i added values here..Any one has any idea about this..Actually my intention is to remove the error "the insert statement conflict...
SQL Server 2005 config file path of databases loaded
I need to find the path of the database (MDF) or at least the database logs loaded but for some reasons I cannot login through the SQL Server so I need to know if you know any file/config file that keeps the path of the databases or log file . ...
how to use .mdf while developing
I use a .mdf database for my asp.net Mvc project. The project is on source control on a tfs. When I debug the project, Visual Studio copies the database in to the debugmap. The problem is, when I debug next time, the changes (while testing the previous time) in the database are gone. The reason of this I know, Visual studio copies the o...
ASP.NET MVC 2 Membership users table mdf file
I have an MVC 2 project where I have my own *.mdf file in the App_Data directory. The *.mdf file contains my normal tables but not a users table. Is it possible to add a Users table to my *.mdf file and work with that instead of the simple register form? (if so: how could this be done?) Because I don't know how to do these things above...
Cannot connect to MDF file using VS 2008 Server explorer
Hi, as mentioned in title. Another details: file is in on my hard drive in App_Data directory I have Microsoft SQL Server 2005 on my localhost installed (full, not Express edition) When I try to connect to file using Server explorer Microsoft SQL Server Database File I get an error: network-related or instance-specific error occ...