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
4 answers

SQL Server 2008 Express one row write

I have the most bizarre problem (at least it is bizarre to me) with SQL Server Express 2008. The problem is the following: On the development machine I use SQL Server 2008 Enterprise....I get some data from a WCF service and write that data to the…
TheBoyan
  • 6,802
  • 3
  • 45
  • 61
0
votes
1 answer

SQL Server 2008 Express doesn't see my Visual Studio 2008 Team System's SP1

I want to install SQL Server 2008 express. I have already Visual Studio 2008 Team System with SP1. VS in help > about shows me: MVS version: 9.0.30729.1 SP .NET Framework version: 3.5 SP1 but installator of SQL Server shows me that Visual Studio…
Kamilos
  • 795
  • 2
  • 10
  • 25
0
votes
0 answers

Transferring 3 SQL databases from both SQL Server 2005 Express and Standard to a new physical server

I am trying to figure out the best method for transferring SQL Server 2005 databases from 2 different physical servers to a new server running Windows Server 2008 64bit. I own a fully registered copy of Microsoft SQL Server 2005 32bit Standard…
Dixie Admin
  • 1
  • 1
0
votes
2 answers

Inserting data into a SQL Server express database

I am trying to insert customer details into a database. Following is the code which is throwing an ArgumentException - how can I handle it? try { string constring = "DataSource=.\\SQLEXPRESS;"+"Integrated security=true;"+"User…
Vrij Sharma
  • 1
  • 3
0
votes
2 answers

SQL Server Express 2008 Stored Procedure execution time spikes periodically

I have a big stored procedure on a SQL Server 2008 Express SP2 database that gets run about every 200 ms. Normal execution time is about 50ms. What I am seeing is large inconsistencies in this run time. It will execute for while, say 50-100 times…
user156241
  • 51
  • 4
0
votes
1 answer

Save All Values of Database to Text File?

I was wondering if there was a way to extract all the values of a column, and then save each value into separate text files (labeled ANYTHING, 1-100 works fine). I know how to do this through another language, but I'm using SQL Server 2008 with…
cam
  • 8,725
  • 18
  • 57
  • 81
0
votes
2 answers

SQL Server Express 2008

I am going to install Visual Studio 2010 Premium. I have SQL Server 2008 Express already installed on my laptop along with Visual Studio 2008 Professional. Do I have to uninstall SQL Server 2008 Express or will it be configured to operate in the…
robblot
  • 395
  • 2
  • 5
  • 15
0
votes
1 answer

Program runs without error but not giving desired output

Following program extracts data from SQL Server 2008 tables, applies a simple for loop and counts total number of records. Program compiles and runs successfully without any error but doesn't print the total count of records to the screen. It…
Lattar Singh
  • 9
  • 7
0
votes
3 answers

NHibernate mapping error SQL Server 2008 Express

I tried an example from NHibernate in Action book and when I try to run the app, it throws an exception saying "Could not compile the mapping document: HelloNHibernate.Employee.hbm.xml" Below is my code, Employee.hbm.xml
developer
  • 5,178
  • 11
  • 47
  • 72
0
votes
1 answer

Connect to SQL Server 2008 Express database using C#

I am developing a Winforms application in which I am using SQL Server 2008 Express Edition as backend. But I am getting error: Additional information: An attempt to attach an auto-named database for file…
Ubiquitous Developers
  • 3,637
  • 6
  • 33
  • 78
0
votes
1 answer

Can I Install SQL Server 2008 R2 express edition on Windows xp 32bit?

I am trying since 2 days. I was able to Install but I Cant see my all services in 'SQL Server Configuration Manager and I cannot access sql server management studio. It works fine on my windows 7 laptop and it have all the services. Xp have only…
Ragini Shukla
  • 41
  • 1
  • 2
  • 8
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
1 answer

"The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" How to resolve this issue?

I am having date in 14/08/2014 12:33:50 PM( as TXNDate) and i am getting result 2014-08-14 13:19:38.153 if I select current date using GetDate() function. Now, my query is that I am having table 'EmpHistory' in which I want only those rows whose…
Rupesh S
  • 125
  • 1
  • 14
0
votes
1 answer

Reorganizing indexes and database size

I have a fragmentation problem on my production database. One of my main data tables is about 6GB(3GB Indexes) (about 9M records) in size and has 94%(!) index fragmentation. I know that reorganizing indexes will solve this problem BUT my database is…
Rafał.S
  • 186
  • 2
  • 14
0
votes
1 answer

SQL Server 2008 Express Query

I am having trouble getting the following query to work properly: SELECT tblEmployees.iEmployeeNum AS ID, tblEmployees.tLastName AS SURNAME, tblEmployees.tFirstName AS NAME, pInt.dtEventReal AS 'ENTRANCE', pIes.dtEventReal AS 'EXIT' FROM …
Chris19
  • 210
  • 7
  • 17
1 2 3
…
22 23