Stack Overflow
Stack Overflow

Questions tagged [sql-server-express]

Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.

1718 questions
0
votes
3 answers

Copy data from SQL Server Express keep primary key

I want to copy data from a database to another, but I'd like to keep the primary key from the original database so it won't mess with the relationships. I'm using SQL Server 2008.
Eduardo Mello
  • 925
  • 3
  • 15
  • 32
0
votes
2 answers

Data Import in SQL Server Express

SQL Server Express does not have the Tasks -> Import Data option that other editions of SQL Server has. Has anyone come across a free tool to import data? I understand I can use the bulk import but I have run into a security issue with it and would…
user300981
  • 1,423
  • 5
  • 13
  • 16
0
votes
2 answers

Sync Framework questions

Okay so I have to sync data between two SQL Server Express instances and after a research I stopped at Sync Framework which I think can do the job.. but since I am pushed by time and I don't have much time to do a complete research I need to ask few…
zhv89
  • 9
  • 5
0
votes
1 answer

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…
aubreyrhodes
  • 777
  • 4
  • 16
0
votes
1 answer

In Entity Framework code-first, why can't I use SQL Server Express in the connection string?

I'm building my first ASP.NET MVC application using the code-first approach. When I changed the default connection string's "Data Source" from: Data Source=(LocalDb)\v11.0 to Data Source=.\Sqlexpress I encountered error about an error contains…
Dabbas
  • 3,112
  • 7
  • 42
  • 75
0
votes
2 answers

Reporting System architecture for better performance

We have a product that runs Sql Server Express 2005 and uses mainly ASP.NET. The database has around 200 tables, with a few (4 or 5) that can grow from 300 to 5000 rows per day and keep a history of 5 years, so they can grow to have 10 million…
pauloya
  • 2,535
  • 3
  • 30
  • 50
0
votes
1 answer

Conflict Sql Server Express on Server and Desktop

I am trying to develope a basic sql database driven application using visual basics 2010 Express. An application which can be used on all pc's connected to the network. We have a small company network and the server is running SQL-server 2008…
Ferdinant
  • 1
0
votes
2 answers

Replacing SQL Anywhere DB in PowerBuilder Legacy System

I have inherited a legacy system written in PowerBuilder which connects to an SQL Anywhere 5.5 database via ODBC. The Sybase drivers are not 64-Bit compatible so this system is throwing errors and there are no updated drivers available. I do not…
user3850146
  • 97
  • 1
  • 11
0
votes
1 answer

SQL Server : can't login with Windows Authentication

We bought a virtual dedicated server. Then I installed SQL Server Express on it. And then I installed SQL Server Management Studio to run this on windows server 2008. But I cannot connect the database. It gives me a "cannot connect error". How can I…
Ender Ariç
  • 49
  • 1
  • 1
  • 10
0
votes
1 answer

Does SQL Server Express support FileTable

Does SQL Server Express support filetables? If not, what's the nearest approach to filetables in SQL Server Express?
Mahdi Tahsildari
  • 13,065
  • 14
  • 55
  • 94
0
votes
1 answer

What is a proper "Connection String" for my C# app?

The word is, I would like to run my C# app on a computer with Windows XP and SQL Server 2008 R2 Express installed. Although I tried any possible connection strings, I could not run my App on that computer. Any help will be highly appreciated. I…
Shadan Golestan
  • 106
  • 1
  • 6
0
votes
3 answers

want to use my ongoing asp.net website on desktop

I am very new to asp.net. Infact all i know till date is through web :) I have build a website which is working fine. but now due to some reasons i have to convert it into a desktop application. I want both of them to be working. My questions: a)…
Ashi
  • 3
  • 3
0
votes
1 answer

SQL Express 2010 how to remove empty text fields from a select query

I've been banging my head against a brick wall for this for ages. I am trying to query a table in SQL Express 2010. There are about ten fields in the table. One of the fields is a text field. Some of these have text in them, some have none (I am…
HMcGoonish
  • 57
  • 7
0
votes
1 answer

Find database in SQL Server Object Explorer

I am using VS2013 Express Web Edition and I have coded a C# MVC 5 Internet application, and wish to delete the database from the SQL Server Object Explorer. Here is my connection string: "Data…
Simon
  • 7,991
  • 21
  • 83
  • 163
0
votes
0 answers

Upgrade SQL Server 2008 Express database file to 2012 programmatically in C#

How can I upgrade my SQL Server Express database file from 2008 to 2012 using C#? I made program a few years ago. Now, I want to create an exe file for a customer, which should upgrade the database file to the 2012 database version.
shahriyar abbaspoor
  • 1
  • 2
1 2 3
…
99 100