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

How can I export a SQL Server 2008 database?

Is it possible to export my database that i created in SQL Server 2008 Express? I'm asking this because I need my group mate to be able to work on the same one. I know you can generate a script for the database but it give a bunch of errors when we…
Dynamiite
  • 1,419
  • 5
  • 21
  • 28
5
votes
3 answers

Merging column values in many to many relationship joins

I have two tables, Books and Authors, with many-to-many relationship between them through a third table called book_authors, i am trying to list all the books with the authors for each book using an inner join in order to display them in a DataList…
Ibrahim Najjar
  • 19,178
  • 4
  • 69
  • 95
4
votes
1 answer

Does SQL 2008 Express supports Change Tracking

Due to the lack of documentation for this on MSDN, I am forced to ask here. Does the Express version support the same Change Tracking Feature(s) as the other editions does? Thanks leppie
leppie
  • 115,091
  • 17
  • 196
  • 297
4
votes
4 answers

25k Inserts Daily, 99% Fragmentation on Clustered GUID Index

I have a table that has a primary key as a clustered GUID field; I'm generating GUIDs using NEWSEQUENTIALID() instead of NEWID. Unfortunately, because this table sees ~25k-100k inserts per day, within a few hours the (default: clustered) primary…
ashes999
  • 9,925
  • 16
  • 73
  • 124
4
votes
5 answers

Including a named instance of SQL Server 2008 Express with my application

Good morning, all. This is my first question on stackoverflow, so hopefully this isn't something that's been beaten to death and I haven't been able to find it. I'm developing an application that is going to be distributed shrinkwrapped. We have…
Adam Robinson
  • 182,639
  • 35
  • 285
  • 343
4
votes
2 answers

Can I use datasource=.\\SQLEXPRESS or do I need to now use: machinename\\SQLEXPRESS

Can I still use datasource=.\SQLEXPRESS or do I need to change it to : machine_name\SQLEXPRESS for a local instance of SQL Server 2008 Express in C#? My connection string worked fine in SQL Express 2005, but with the same settings no longer works…
tdjfdjdj
  • 2,391
  • 13
  • 44
  • 71
4
votes
3 answers

Add user to SQL Server 2008 - permission denied

I have recently had some problems that I think might be helped by debugging my ASP.NET MVC application in IIS instead of with the default ASP.NET Development Server. However, when I try this the application can't access the database server (MS SQL…
Tomas Aschan
  • 58,548
  • 56
  • 243
  • 402
4
votes
1 answer

How to Bind DataGridView with SqlDataReader

Can anyone help me in this Code Please. I am trying to bind data with datagridview. Query is returning values in sql server. But it's not binding any value in DataGridView.... private void CheckMembers() { try { …
Mistr Mowgli
  • 131
  • 1
  • 3
  • 10
4
votes
1 answer

Creating a database authentication for SQL Server 2008 Express

In order to have a cross-domain access to my test instance of SQL Server I need a login with a database user and not with a Windows user. Once this would work I could start doing this from my *NIX environment, but basically Windows won't let me…
qwerty_so
  • 35,448
  • 8
  • 62
  • 86
4
votes
2 answers

SQL Server 2008 R2 Express, service stopping on server

I have a virtual windows server with SQL Server 2008 R2 Express. for the last couple of days When I get up in the morning and check my site, its down, as the SQLEXPRESS service is stopped. I have never had this problem before and its very…
JGilmartin
  • 8,683
  • 14
  • 66
  • 85
4
votes
1 answer

Sql Server 2008 Express Edition Licensing

I'm deploying a web application into a server (hosting company). The application uses Sql Server 2008 Express Edition as its database. It seems from the license agreement that this state is ok, as Microsoft says: "All editions of SQL Server Express…
Lord B.
  • 43
  • 1
  • 1
  • 3
4
votes
1 answer

SQL Server Express : how to allow remote connections

I am trying to allow remote connections for SQL Server Express. When I connect from machine A to connect to SQL Server on machine B using Visual Studio, I get an error: A network-related or instance-specific error occurred while establishing a…
user476566
  • 1,319
  • 3
  • 26
  • 42
4
votes
2 answers

How to Bootstrap SQL Server 2008 Express SP1?

I am trying to bootstrap SQL Server 2008 Express SP1 into my application. Previously I used Wise for Windows to perform the prerequisite installation, but Wise doesn't support Windows Installer 4.5 yet. I am now trying to use the Visual Studio 2008…
Rob Hunter
  • 2,787
  • 4
  • 35
  • 52
4
votes
5 answers

SQL Express 2008 - what's a reasonable application size for its 'limitations'?

Without wanting to sound too stupid, SQL Express is free and the free resources make it a good choice for a beginner like me. I know it has limitations (read other posts) but the figures mean little to me I'm afraid. Can anyone give me ball park…
RocketGoal
  • 1,485
  • 8
  • 28
  • 34
3
votes
5 answers

How to add SQL Server 2008 Express to List of Prerequisites

How can I add SQL Server 2008 Express to the list of Pre-requisites in Visual Studio 2008 SP1 MSI Installer Project.
Kishore A
  • 1,293
  • 3
  • 16
  • 21
1 2
3
…
22 23