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

How does SQL Server Express concurrenct connections work?

I would like to know how the concurrency works in SQL Server Express database. The reason I am asking this is because testing my database to be used to create an email server which can send multiple email campaigns at the same time, I noticed that…
Kurumas
  • 1
  • 1
0
votes
2 answers

Added new field to table and to stored procedure, now procedure returns no results

I recently added a Deleted column to my table and then wanted to add an additional where clause but now I'm not getting any results anymore (it returned results before I added the deleted column) SELECT tblEquipment.*, tblUsers.* FROM …
AlexW
  • 2,843
  • 12
  • 74
  • 156
0
votes
3 answers

How to find DISTINCT values from columns with similar names

I've read many posts with similar questions, but haven't found an answer yet. I'm quite new to SQL. Using SQL Server Express 2008. My goal is to get a single-column result of all values that are distinct among several columns with similar names. …
XKCD137
  • 357
  • 4
  • 14
0
votes
0 answers

reconnect default database man studio SQL express (4064 error)

I have SQL Server 2008 Express and Management Studio installed on my laptop I get an error: Cannot open user default database. Login failed I've been googling for hours trying to resolve this but I'm well out of my depth I can't log on to master…
Sonny123
  • 107
  • 1
  • 3
  • 12
0
votes
1 answer

How to make .bak file for SQL Server 2008 Express

How to create a .bak file for selected database table in SQL Server 2008? I have a TESTDB database which have more than 15 tables. I want to make .bak file only for 5 selected tables. So how can I create that?
AJ027
  • 51
  • 2
  • 5
0
votes
2 answers

EF4/5 autogenerates LocalDb databases: what's the SQL Server equivalent?

I've been developing a web application that uses Entity Framework 5 as the ORM. EF5 will auto-generate a file for each new database I want (with its default behavior with no connection string but…
Brannon
  • 5,324
  • 4
  • 35
  • 83
0
votes
1 answer

Error upon installing SQL Server 2008 Express

I am trying to install SQL Server 2008 Express but get the error set.exe is not a valid Win32 application I do not have that much disc space on this machine as it is at the moment, only 10,5 gig, is this perhaps the problem? Any advice perhaps on…
Arianule
  • 8,811
  • 45
  • 116
  • 174
0
votes
1 answer

Error in remote connect to SQL Server 2008 Express

My program cannot connect to SQL Server 2008 Express remotely, the connection string is Data Source=192.168.0.100\sqlexpress;Initial Catalog=xxx; Persist Security Info=True;User ID=sa;Password=xxxx I have checked all the configurations, the…
user2172321
  • 11
  • 4
0
votes
3 answers

Division inside Insert stored procedure T-SQL

I'm new to T-SQL and I was wondering if it's possible to do something like this CREATE PROCEDURE [SISACT].[new_activo_fijo] @activo VARCHAR(8) , @descripcion VARCHAR(60) , @utiliza_serial BIT, *@serial VARCHAR(20) = NULL,* …
Splendonia
  • 1,329
  • 3
  • 37
  • 59
0
votes
0 answers

how to add connection to sql 2008 mdf file from the vista partition in w 8 visual studio 2012

the original app in vista partition was using the connectionstring like Data Source=.\SQLEXPRESS; AttachDbFilename=c:\MDF\StringTmp.mdf;Integrated Security=True; Connect Timeout=30;User Instance=True I have migrated the app's project to visual…
gg89
  • 372
  • 3
  • 11
0
votes
1 answer

Bulk load: An unexpected end of file was encountered in the data file

I am using SQL Server Express 2008 When I'm trying load data from txt file in to this table create table Clients ( ClientID int not null IDENTITY (9000,1), LastName varchar (30)not null, FirsName varchar (30)not null, MidInitial varchar (3), DOB…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
1 answer

SQLite Trigger to SQL Server Express 2008

I need help on SQL Server syntax to create some triggres that I´ve used with success on SQLite, but I'm having trouble with NEW.Table once it´s not part of SQL Server. That´s my SQLite trigger code: UPDATE EngineeringItems set ElevacaoFIT =…
user2083234
  • 211
  • 2
  • 4
0
votes
1 answer

How can I start SQL Server Browser?

I've installed 2008 Express, named SQLEXPRESS and I need SQL Server Browser up and running, but how can I do this? I've tried to set the startup mode to "Automatic" but when I click to save it stats that the service can not be started, because the…
Jason94
  • 13,320
  • 37
  • 106
  • 184
0
votes
5 answers

Copying Data from SQL Server 2008 to SQL Express

I would like to copy a database (tables, it’s data, stored procs & views) from SQL Server 2008 database to SQL Server Express. Is it possible? If so, would you please let me know how to do it? When I tried, it is giving some error. Please note that…
user173329
  • 75
  • 4
  • 6
0
votes
1 answer

How to deploy wpf application with SQL Server Express 2008 in visual studio 2012?

We have a wpf application in .Net Framework 4 and using SQL Server Express 2008 as database when developing. Now we want to deploy it. How to package the DB and generate an installer for the user to download and install it to their machines using…
H LIU
  • 5
  • 2
1 2 3
…
22 23