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
2
votes
1 answer

Problems upgrading to SQL Server Express 2008 SP2

Just this morning, I installed SQL Server 2008 Express SP2 from the Web Platform Installer. When I went to restore some databases, the error message was that my database files are from version 10.5 and I have version 10.0.4000. I tried downloading…
101010
  • 14,866
  • 30
  • 95
  • 172
2
votes
4 answers

Limited memory usage of sql server 2008 express?

I want to install sql server 2008 express on my laptop that has 1 GB memory, but my database contains lots of binary data that I don't want spending all my RAM. I would much rather sacrifice sql performance (make it page) in favor of other…
BC.
  • 24,298
  • 12
  • 47
  • 62
2
votes
3 answers

How does the Data Type of an SQL table's PK impact query performance?

How does the Data Type of an SQL table's PK impact query performance? Specifically, I am interested in: What is the difference between string datatypes (e.g. nvarchar(n), varchar(n)) and numeric datatypes (int, bigint, uniqueidentifier)? What is…
smartcaveman
  • 41,281
  • 29
  • 127
  • 212
2
votes
2 answers

How to debug query timeout in SQL Server?

I'm getting an SQL query timeout for a simple query: delete from Prices where Id=123 Id is a PK column. The server is not under high load - something is wrong with few other queries. How can I debug this situation? I use SQL Server Express…
Nikolay R
  • 957
  • 2
  • 11
  • 22
2
votes
1 answer

facing error while creating setup in visual studio 2017

A dialog window relating to SQL Management Studio appears with the following Please wait while Windows configures SQL Server 2008 R2 SP2 Management Studio. On top of that dialog window a further dialog window appears with: 0: Watson 1: 1304 2:…
Shivvanand Patil
  • 139
  • 14
2
votes
2 answers

Scheduling daily task on SQL Server 2008 database

I'm using SQL Server 2008 and trying to make schedule to run a page every mid-night but I don't know how to do it. I already tried to do with SQL JOBS but couldn't find JOB folder.
Jay
  • 1,384
  • 1
  • 17
  • 30
2
votes
3 answers

SQL table change distribution

I have a WinForm application built with VS 2008 (C#) and SQL Server Express 2008 that is currently deployed on test users PC. I have modifications to do on the database structure (add fields, tables, etc.) and I wonder what's the best method to…
izokurew
  • 448
  • 1
  • 4
  • 15
2
votes
3 answers

Simplest SQL query never returns

I have a SQL query that is quite simply select * from tblOrders where customerID = 5000but it never returns. I waited 10 minutes and gave up. The weirdest thing is that other queries on the same DB, but on another table, works fine. Removing the…
Christian Wattengård
  • 5,543
  • 5
  • 30
  • 43
2
votes
2 answers

How to install SQL Server 2008 Express with Inno Setup?

anyone have script or procedures to install SQL Server 2008 Express, set up the database for the app and finally install a client .NET WinForm application?
Chris Woodruff
  • 1,323
  • 3
  • 14
  • 30
2
votes
0 answers

add data collection component sql server 2008

I have been searching for hours, and I can't find a way to add data collection component in object explorer , ps: I'm using sql server 2008 r2
user3676872
  • 204
  • 1
  • 12
2
votes
1 answer

Services not visible in SQL Server Configuration Manager

I have installed SQL Server 2008 Management Studio Express 32 bit. I have installed it successfully but when I try connect with SQL Server I am getting an error Then I thought to turn the services ON from SQL Server Configuration Manager but I am…
Garvit Gupta
  • 189
  • 1
  • 5
  • 15
2
votes
1 answer

SQL Server 2005: what LINQ generated query is better - with "Where()" or "Any()"?

var query = from c in db.Customers select c; query = query.Where(c => c.Orders.Where(o => o.OrderItems.Where(oi => oi.SellerID == sellerID).Count() > 0).Count() > 0); that generates SQL: SELECT [t0].[CustomerID], [t0].[FirstName], [t0].[LastName],…
Zelid
  • 6,905
  • 11
  • 52
  • 76
2
votes
3 answers

Normalized Database Question

I should know this but I expect it to be a simple answer... This is my simple database so far for this question: Am I supposed to insert the Id from Contact and Phone into Contact_Phone when I insert a record into Contact and Phone tables - or can…
user195488
2
votes
2 answers

Move database from SQL Server 2008 Express to SQL Server 2012

We are looking at migrating one of our databases from SQL Server 2008 Express to SQL Server 2012. The guy that has been taking care of the database says he always does a detach, copy the files to the new server and attach. This takes the database…
Toolman21
  • 47
  • 2
  • 7
2
votes
1 answer

How to copy a MSDE database to SQL Server 2008 Express?

We have a client environment that has MSDE. We're looking to install SQL Server 2008 Express on the clients but must retain MSDE for other applications. Assuming both MSDE and SQL Server 2008 Express exist on a single machine what options are…
byanity
  • 203
  • 1
  • 4
  • 14
1 2 3
…
22 23