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

Visual C# 2008 Express connection to SQL Server 2008 Express Issue

I have a problem with Visual C# 2008 express (SP1) connecting to SQL Server 2008 express. The "Add Connection" window (wherever initiated) doesn't list existing sql server and no option for sql server except a compact edition. Note that, I've got…
Phil
3
votes
2 answers

How to import data from Excel into SQL Server Express 2008 in MVC3

I'm using MVC3 with C# code. I have a table in my SQL Server Express containing some columns, and I have an Excel sheet which has the same number of columns with the same datatypes and names. My requirement is I want to browse that Excel file in my…
Sam M
  • 1,077
  • 2
  • 20
  • 42
3
votes
4 answers

SQL Server 2008 Datetime field overflow

I am using C# to interface with a SQL database. the database has a DateTime field. When I try to write a DateTime object from C#, I get the following error: ERROR [22008] [Microsoft][ODBC SQL Server Driver]Datetime field overflow I found this on…
sbenderli
  • 3,654
  • 9
  • 35
  • 48
3
votes
1 answer

hibernate generator won't insert with uniqueidentifier

I'm trying to map an entity using Hibernate Annotations, so that when a record is created and saved (via cascade), an ID is automatically generated. With my current setup (or a few others I've tried) I get the following error: …
RMorrisey
  • 7,637
  • 9
  • 53
  • 71
3
votes
1 answer

How do you get SQLServerExpress to create users?

Running as Administrator on my machine, I can create databases just fine, but when I try to create a user it fails with this error message. 1> create user mark from login mark 2> go Msg 15007, Level 16, State 1, Server ENDER\SQLEXPRESS, Line…
boatcoder
  • 17,525
  • 18
  • 114
  • 178
3
votes
1 answer

How to connect SQL Server 2008 Express?

I can't connect SQL Server Express 2008,I downloaded and installed SQL Server 2008 Express 64Bit, Microsoft SQL Server Management Studio. And I can't connect to the SQL Server, I tried those options Disable the firewall Restart the SQL Server…
Yosy
  • 31
  • 2
3
votes
3 answers

Case and Nested Table in Data Mining

I have very simple Question. Please can anyone explain with example the Case Table and Nested Table in Data Mining. I am using SQL Server 2008R2 SSAS and I am confused with Case Table and Nested Table. If there is any tutorial, Please share. Thank…
Faizan Mubasher
  • 4,427
  • 11
  • 45
  • 81
3
votes
2 answers

SQL Server 2008 Express Integration Services

Does SQL Server 2008 Express support Integration Services? When I try to create an Integration Services project, it says that I have to install Integration Services, but I cannot find the option in the setup for the installation. How can I install…
coffeeak
  • 2,980
  • 7
  • 44
  • 87
3
votes
2 answers

How to Silently Install SQL Server 2008 Express In InstallShield 2010

I use InstallShield 2010 to create my setup. My program needs SQL Server 2008 Express. So I added "Microsoft SQL Server 2008 Express SP1 (x86)" in the redistributables section. Then in "Edit Prerequisites" => "Application To Run" tab, I insert this…
Mahdi Radi
  • 429
  • 2
  • 10
  • 30
3
votes
1 answer

how to instal MS SQL Server 2008 management studio in windows 8?

I am using 64bit Windows 8 rtm. Where can I get Sql server 2008 mgmt. studio for it?I tried installing sql server 2008 express sp1 and SQL Server 2008 R2 Express SP1, but it wont install.(ref:…
user1656381
  • 41
  • 1
  • 1
  • 2
3
votes
2 answers

Which is the simple way to export a database from SQL Server including all tables and data into file.sql file?

I'm using SQL Server[s] 2008 R2 [Express]. I would like to create an installation file.sql file for an example database. In file.sql I mean a file that will run from Microsoft SQL Server Management Studio as a query. I would like to have a single…
Different111222
  • 1,523
  • 3
  • 20
  • 28
3
votes
5 answers

SQL Server 2008 express performance in production environment?

I am about to move servers and i was talking to somebody and they suggested using sql server express 2008 installed on the servers. I have full access to the server. Does this express engine work at the same speed (performance) as a true sql server…
mark smith
  • 20,637
  • 47
  • 135
  • 187
3
votes
1 answer

Getting data from one database table into another database table

I imported data from MS-Access into a SQL database using the import/export wizard. Now, I have database called TestDatabase - With a Table called AccessTable - It has 10 columns. on the same SQL Server, I have another database called SampleDatabase…
kalls
  • 2,797
  • 17
  • 55
  • 75
2
votes
1 answer

How to connect to SQL Server Express DB from Server Explorer VS 2010?

I'm trying to connect to SQL DB from Server Explorer to generate context classes for Linq to SQL. Doing it like described here: http://visualcsharptutorials.com/ado-net/querying-database-linq-to-sql/ I'm getting "This file is in use." error when I…
Burjua
  • 12,506
  • 27
  • 80
  • 111
2
votes
1 answer

Is it possible to rename a SQL Server 2008 Express installation?

I am attempting to install (and un-install and re-install numerously) SQL Server 2008 Express. I selected install as a default instance but the setup insists that my installation be a named instance localhost\sqlexpress. Has anyone else had this…
Steve
  • 159
  • 6
1 2 3
…
22 23