Stack Overflow
Stack Overflow

Questions tagged [sql-server-2008-express]

SQL Server 2008 Express is a free edition of SQL Server that is an ideal data platform for learning and building desktop and small server applications, and for redistribution by ISVs.

Microsoft SQL Server 2008 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded application clients, light Web applications, and local data stores.

It is a version of Microsoft's SQL Server relational database management system that is free to download or distribute. It comprises a database specifically targeted for embedded and smaller-scale applications. The product traces its roots to the Microsoft Database Engine (MSDE) product, which was shipped with SQL Server 2000. The 'Express' branding has been used since the release of SQL Server 2005.

340 questions
0
votes
1 answer

SMO install database via Backup

The project I'm working uses SMO to restore the needed databases as part of the application installer. The problem is, on a machine that has never had the application installed. From the event logs, it seems like the database can't be restored…
Zachary Yates
  • 12,966
  • 7
  • 55
  • 87
0
votes
1 answer

Prepared Statements and Stored Procs Used Together

I'm in the planning stages of a Microsoft ASP.NET / SQL Server 2008 based web application and In thinking about database design, I began to think about injection attacks and what strategies I should employ to mitigate the database as a vector for…
Crippledsmurf
  • 3,982
  • 1
  • 31
  • 50
0
votes
1 answer

Sql Select 0 1 0 1 sequence from database table

I need to fetch output from given below table in 0 1 0 1 sequence .All other data at the end of table. create table #Temp ( EventID INT IDENTITY(1, 1) primary key , Value bit ) INSERT INTO #Temp(Value)…
Gaurav
  • 5
  • 4
0
votes
1 answer

Connection string in web.config not working

I have a very basic ASP.NET web application that is connecting to a SQL Server database (I am using SQL Server 2008 Express). The problem I am having it is very odd: if I set the connection string for the SqlConnection object directly in code, the…
Alan Espinet
  • 114
  • 6
0
votes
1 answer

Visual Studio keeps asking to install SQL Server

I am using Visual Studio 2012 working on a web application, a registration page. I have installed SQL Server 2008 Express and done the configuration but still when when I try to add a SQL Server database file in the project, I get an error…
Noshairwan Farooq
  • 91
  • 1
  • 10
0
votes
1 answer

Send e-mail when a row changes

I will try to best explain what I would like to do (for simplicity I only included two columns that I am working with): I have two different tables, dbo.device and dbo.devicestatus. They are both tied by DeviceDN which is primary key. On…
Alex
  • 1
  • 1
0
votes
1 answer

SQL Server Query Sum By Date And Sum All

I have columns Date, Country and Dollars. I am successful if I query like this picture... My query is: select date, country, sum(car), sum(dollar) group by date, country union select '' as All_Date, '' as All_Country, sum(car), sum(dollar) group by…
SimanisJKT48
  • 104
  • 1
  • 11
0
votes
1 answer

VS 2010 C# Create Setup File with SQL Server database

I'm trying to create a working installer or setup file for an application I created using C# in VS 2010. I used InstallShield and also the built-in one and they do created the setup files and I installed the app with no problem. But when I ran the…
Ikawa Afue
  • 39
  • 1
  • 6
0
votes
2 answers

Visual Studio 2008 with SQL Server 2005 Developer Edition

I am trying to add a database to the App_Data location in an ASP.NET MVC 2 application in Visual Studio 2008 (VS). I have SQL Server 2005 Developer Edition installed on the local machine. However when adding the database VS complains that SQL Server…
zzawaideh
  • 2,021
  • 1
  • 17
  • 25
0
votes
1 answer

Uninstalling VS Setup project prerequisites

We currently use a VS 2010 (upgraded from 2008) setup project to install our application, and utilize the SQL Server 2008 install prerequisite. Well wouldn't you know, management has got it in their head that everything (including prerequisites, but…
Saint Domino
  • 1,362
  • 1
  • 11
  • 20
0
votes
3 answers

SQL Server 2008 Express : find similar records in a table

Here is my first question about a SQL Server 2008 Express database, containing articles, quantities, prices and so on. Unfortunately when I loaded data the first time I loaded articles making the following mistake: I created two records for (almost)…
Francesco Tattoli
  • 82
  • 1
  • 10
0
votes
1 answer

installing and configuring sql server and IIS for asp.net 3.5 database app [basic]

I'm very sorry about this being a very cliché question, but I really need to understand some specific things. Everytime I add an sql server database in visual studio 2010 it creates a database under App_Data and then the connection string the server…
gideon
  • 19,329
  • 11
  • 72
  • 113
0
votes
2 answers

SQL Server 2008 Express Clear Recent Connection List

I was trying to remove my recent connection list by deleting the mru.dat (in Application Data folder under windows xp) file as pointed out in numerous tutorial over the internet(I just googled it) but was unable to find it. How am I supposed to…
Soham Dasgupta
  • 5,061
  • 24
  • 79
  • 125
0
votes
2 answers

What could be the reason for SQL Server Express to roll back a database to a previous state?

I have some very strange problems. I have an application running on Windows 2003 terminal server from multiple clients. The application uses SQL Server 2008 Express as its database. Yesterday, I connected to the app, closed some sessions on the…
ericpap
  • 2,917
  • 5
  • 33
  • 52
0
votes
1 answer

Why Do I See the "In Recovery" Msg, and How Can I Prevent it?

The project I'm working on creates a local copy of the SQL Server database for each SVN branch you work on. We're running SQL Server 2008 Express with Advanced Services on our local machine to host it. When we create a new branch, the build script…
John Hansen
  • 123
  • 1
  • 11
1 2 3
…
22 23