2
голосов
1ответов
1886 просмотров

SQL express 2008 restore from a SQL Server 2008 backup

I have done some research online but i cant seem to find a proper answer. I am trying to restore a SQL server 2008 backup onto a sql express 2008 system (Live environment backup to Development environment) The problem is i keep getting a "SQL Server cannot process this media family" error code 3...

1
голосов
4ответов
638 просмотров

SQL Server Express for ASP.NET Intranet?

We are looking at creating a custom ASP.NET application for a client, however they are a nonprofit and thus budget is limited. We typically develop ASP.NET web and desktop apps to connect to a central SQl Server 200X database, ie with a full version of SQL Server, running on networked Windows Se...

0
голосов
1ответов
213 просмотров

Visual Studio Model Won't Show SOME New Tables

I added some tables to my DB, and refreshing the model didn't work. So I deleted my .edmx file completely. I then recreated the model according to my updated DB, but the same tables were still missing. I'm not really sure why, but for some reason it won't load certain tables into the model. I...

1
голосов
1ответов
836 просмотров

Can I upgrade SQL Server express to Standard version on different machine

If I have a new install of SQL Server Standard on one machine, can I easily import my database from SQL Server Express on another machine? I was planning to detach the db transfer the file and attach on new machine. Is this the easiest way? What about permissions? Will this work?

0
голосов
1ответов
294 просмотров

SQL Server Express backup restore not working for asp.net membership

I am backing up a SQL Server Express database and then restoring on another machine. For some reason the asp.net membership data is not getting transferred. Do I need to do something different. Does ASP.NET membership data not get backed up?

1
голосов
5ответов
1246 просмотров

Linq with MySql

Is there a free solution for using Linq and MySQL? Can one use Visual Studio Express, Linq, and MySQL together?

0
голосов
2ответов
938 просмотров

Visual Studion 2008 App_Data defaults

Is it possible to use the App_Data folder in conjunction with SQL Server 2005? When I try it specifies Express even though I have changed the Tools>Options>Database>Data Connections to the correct server. I have downloaded SQLEXPR32_x86_ENU.exe Version 10.0.1600.22 file locally and hav...

1
голосов
1ответов
1316 просмотров

Database connection in Dreamweaver CS4 - grayed out

I am able to create a database connection when I use ASP (vb) but when I switch my document type to ASP.NET (vb), my add database connection is grayed out. How can I add a SQL database connection while using ASP.NET (vb)?? PS - it is the "+" symbol that is grayed out.. it works fine when I switc...

0
голосов
3ответов
425 просмотров

"Silent" errors in .ADP with SQL Server

I have an adp project in MS Access 2003 with an SQL Server Express 2008 as backend. Everything works fine, except when there is an error on the SQL side, e.g. duplicate indices. the current dataset just doesn’t get updated/inserted, no error message whats-o-ever, but I know it’s not updated, bec...

0
голосов
1ответов
613 просмотров

Adding SQL Server Express Edition SP3 as Project Requirement

I'm deploying my Web project and in the requirements I mention that I need SQL Express Edition SP2 (x86) as you can see by the picture below alt text http://www.balexandre.com/temp/2009-09-25_1107.png Problem is when the client has already Microsoft SQL Server 2005 Express Edition SP3 (this on ...

1
голосов
3ответов
2627 просмотров

User Instance Failure error when creating a Service-based database in VS 2008 and using SQL Server Express 2005 on Windows 7

I just installed SQL-Server Express 2005 on my machine and I am trying to create a Service-based Database for a C# application. But when I try to create it I end up with the following error message: Failed to generate a user instance of SQL Server due to a failure in starting the process for th...

6
голосов
5ответов
19809 просмотров

How to attach .mdf file to .SQLEXPRESS

Tried this in as connection string connectionString="Server=.\SQLEXPRESS; AttachDbFilename=E:\Database\dnn49.mdf;Database=dnn49; Trusted_Connection=Yes;" but i get an error Unable to open the physical file "E:\Database\dnn49.mdf". Operating system error 5: "5(Access is deni...

1
голосов
1ответов
1958 просмотров

How to use SQL membership with transaction scope (without DTC)?

I'm trying to create a user using the SQL membership provider on SQL Express. When I use the TransactionScope it prompts to DTC with no apparent reason, how can I avoid it? Here is my example code: using (var ts = new TransactionScope()) { MembershipCreateStatus status; Membership.Creat...

1
голосов
3ответов
342 просмотров

How to create SQL Server Express DB from SQL Server DB

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 synchronizatio...

7
голосов
3ответов
10061 просмотров

Getting "SQLExpress database file auto-creation error" for site that uses AspNetSqlMembershipProvider, but connection string is to SQL Server 2005

I have an ASP.NET v2.0 website (not web application) where the root directory is public, but the "Admin" subdirectory requires authentication. Everything about the setup is very generic - I used a connection string defined in the root web.config, and the standard AspNetSqlMembershipProvider prov...

0
голосов
1ответов
797 просмотров

Measuring performance hits between SQL Server database and SQL Express User Instances (.mdf type database files)

Has somebody measured performance differences between "real" SQL Server database and a SQL Server Express user instances (attached .mdf database file)? What was the conclusion? Was the .mdf database file fast enough for your application?

1
голосов
2ответов
2130 просмотров

SQL Server 2005 Express installed after SQL Server 2008 Express

I already had the SQL Server 2008 Express engine installed (just the bit that comes with VS 2008 Express). I then installed SQL Server 2005 Express followed by SQL Server 2005 Management Studio Express, all of which seemed to install OK without any errors. However, when I run SQL Server 2005 Mana...

2
голосов
3ответов
1898 просмотров

Maintain a single connection or open only when i need to change something?

I have an SQL server on a server at home (which is an Atom processor with 1GB ram), and i'm using it to store data for one or two of my applications. I was wondering if i should create a DataContext object when the program starts then hold onto it for the entire life of the app, or only create t...

21
голосов
2ответов
10963 просмотров

How to insert into a table with just one IDENTITY column (SQL Express)

Pretty much the same as this question. But I can't seem to get this to work with SQL Server Express in Visual Studio 2008. Same Table layout, One column with identity and primary key.

23
голосов
3ответов
23441 просмотров

How do you backup and restore a database as a copy on the same server?

I have a SQL2005 Express database that I would like to create a copy of on the same instance. How do you go about doing this with a script? I already have a script for generating the backup, but the restore is failing... THE ERROR: Msg 3234, Level 16, State 2, Line 2 Logical file 'MyDB_d...

20
голосов
8ответов
55714 просмотров

How do I connect to a SQL database from C#?

I am trying to write a local program management and install system for my home network, and I think I've got the technologies nailed down: C#/.NET/WPF for the client Lua for installation scripting support (through LuaInterface) SQL Server Express for maintaining a database of programs However...

0
голосов
2ответов
1233 просмотров

Link one table to another?

i'm trying to set up some tables in my SQL Express server, and i want to do something to the effect of this: create table programs ( progid int primary key identity(1,1), name nvarchar(255), description nvarchar(500), iconFile nvarchar(255), installScript nvarchar(255) ) ho...

11
голосов
3ответов
52159 просмотров

How to export an entire Access database to SQL Server?

I've just got a lovely Access database, so the first thing I want to do is to move it over to a normal database management system (sqlexpress), but the only solution I've found sounds like craziness. Isn't there an "export database to .sql" button somewhere? I have around 50 tables and this exp...

3
голосов
1ответов
369 просмотров

Why is SQLMetal.exe generating different results for SQL Compact 3.5 and SQL Express 2008 (foreign keys are missing)

Here's the story: I created a SQL Compact 3.5 database and used SQLMetal.exe to generate DataContext for it. It worked well, but soon I realized that it simply does not suit my needs so I decided to go for SQL Express 2008. I fired up the very same SQL script I used for the Compact to create sche...

1
голосов
3ответов
3236 просмотров

Cannot access SQL Server Express 2005 database in VMWARE

I'm running an SQL Server express 2005 database inside a guest OS that I'm trying to connect to via a application running on the host. However, I'm not able to connect to the database (I can connect to the database if I run the application inside the guest OS). Both operating systems are Windows...

2
голосов
6ответов
639 просмотров

Is SQL Server 2005 Express good enough for development

At the company i develop, developers typically run databases on their laptops. We also have an instance of a SQL Server 2005 and SQL Server 2000 servers running as virtual machines, under an MSDN license. I am not a MSDN guru and not really familiar with the ins-and-outs of MSDN, so the my ques...

0
голосов
3ответов
4363 просмотров

DTS for SQL Server 2005 Express Edition

What did Microsoft rename DTS to for SQL Server 2005 Express Edition? Where is the download link to the SQL Server 2005 Express Edition DTS utility? i've been searching for half an hour, and i can't find a definitive answer. i need to import data from a data source into an SQL Server 2005 Ex...

5
голосов
4ответов
18913 просмотров

SQL Express connection string hell ASP.Net

SQL Express 2005 is running locally. I have a project written by another person running on the same machine. All I want to do is connect to it, can't be that hard right? This is the one I use in my old classic ASP code to hit another database running on the same instance: Provider=SQLOLEDB;Data...

5
голосов
6ответов
1686 просмотров

Detect Sql Express From TSQL

I need a safe (i.e consistent, robust) way of detecting whether or not the sql server I'm accessing is Sql Express. I think I'd prefer to be able to do this from TSQL, since I already have a connection string and all the libraries I need to execute TSQL (this should help avoid issues with whether...

0
голосов
1ответов
1045 просмотров

SQl Express changing language

How do you change the Language in SQL Express (2008) to another language like English?