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

How can I select rows and group duplicate results from 2 tables based on data in a third table?

I have 3 tables (SQL Server 2008 Express): CustomerActivity, EmployeeActivity, & ShipperActivity CustomerActivity has data similar to this: CustomerName OrderNumber ActivityDate ------------ ----------- …
bham3dman
  • 77
  • 9
0
votes
1 answer

Linq2SQL locking object in multithreaded environment?

I have an windows service application where I have an object that is processed during rather long time. During the process time the user can interact with the object from a GUI and calling WCF-services on the service. Sometimes, haven't been able…
Johan
  • 23
  • 4
0
votes
1 answer

Testing regional settings (localization) in SQL Server 2008 Express

I'm installing SQL Server 2008 Express along with my application, via a bootstrapper. I need to give users admin privileges for the SQL Server, so an ordinary user can create and manipulate DBs. I was doing it via the bootstrapper with…
noloman
  • 11,411
  • 20
  • 82
  • 129
0
votes
1 answer

Connectionstring mdf file in superior folder

I´ve got the following connectionstring: string connectionstr = "Data Source=.\\SQLEXPRESS;" + "AttachDbFilename=|DataDirectory|\\..\\..\\Datenbank\\FarmersCalc.mdf;" + "Integrated Security=True;" + "User Instance=true;"; As i know, |DataDirectory|…
user896692
  • 2,351
  • 7
  • 36
  • 57
0
votes
1 answer

Creating database and tables in SQL Server Express

I am using SQL Server Express edition for my application (Visual Studio 2010 Ultimate, C#). I found that SQL Management Studio does not support Express edition. I googled the query but didn't find a satisfactory solution to my problem. I've…
Muhammad Ali Dildar
  • 1,467
  • 6
  • 24
  • 35
0
votes
4 answers

SQL Server Express inserts doesn't work anymore

In my C# application, I do the following: using (SqlConnection connection = new SqlConnection(connectionstr)) { connection.Open(); SqlCommand com1 = new SqlCommand("insert into Anfangstierbestand(bestand, jahr, loginid) VALUES (" + bestand…
user896692
  • 2,351
  • 7
  • 36
  • 57
0
votes
2 answers

How to dynamically choose the derived column transformation based on the given flat file

I need to get data from flat files to DB using SSIS. The problem here is, I have to dynamically choose the Derived Column Transformation(DCT) depending on the flat file. Example: Suppose I have flatfile-1 which need the DCT with 5 columns, then if I…
Amarnath
  • 8,736
  • 10
  • 54
  • 81
0
votes
1 answer

Silverlight, SQL Server & Visual Studio: Making test page publicly available on internet

I'm working on a SQL Server 2008 Express + silverlight project, and so far things are working pretty well on the local machine. I've set it up to where the silverlight app connects to the SQL Server using a service reference and LINQ, and I believe…
JoeCool
  • 4,392
  • 11
  • 50
  • 66
0
votes
1 answer

How to call SQL Server Express command line using c# to run a .sql file

I have to make a setup for window application so I need to create a database on client machine. So I decided that I will create it using a .sql file which I will add in my resource file. As there is a option to execute that file on first run of my…
rahularyansharma
  • 11,156
  • 18
  • 79
  • 135
0
votes
1 answer

Add Year Prefix in auto generated id which is a primary key

I want my ID to be autogenerated and want a format like this: 12-0001, 12-0002 12 represent the year 2012 which is the current year of the system date. And my last record for ID is 12-0999 and when 2013 comes I want my ID to change the year prefix…
keizune
  • 37
  • 3
  • 4
0
votes
3 answers

Does SQL Server Express 2008 work on local networks?

I want to connect multiple clients at the same time to a specific database (eg. mydb.mdf) on SQL Server Express 2008 in a local network (LAN). Is it possible or I have to install SQL Server 2008?
Amir Saniyan
  • 13,014
  • 20
  • 92
  • 137
0
votes
2 answers

Synchronisation between SQL Server 2008 Express and VFP tables

I'm looking for advices and suggestions on how to synchronise data between two databases. The first database is a SQL Server 2008 Express that run on disconnected laptops (no network or internet access). The second database (main) is a VFP 9.0 that…
izokurew
  • 448
  • 1
  • 4
  • 15
0
votes
0 answers

Connecting to a remote SQL Server Express 2008 instance on Windows 7 from Java using JDBC (on Mac OS X)

I'm running into some issues trying to connect to a remote SQL Server 2008 Express instance from Java. Here are the specifics: DB Server: Windows 7 running SQL Server 2008 Express Client: Mac OS X (10.6.8) running Java (1.6.0) using the JDBC4…
Mike Monteiro
  • 1,427
  • 1
  • 14
  • 21
0
votes
3 answers

How to maintain database in a separate (portable) SQL file?

I am creating an application for some user to maintain records in database. For this, I'll have to write SQL query (C#) and create the database, if does not exist, when user starts/installs the application. To make the creation and backup procedure…
Muhammad Ali Dildar
  • 1,467
  • 6
  • 24
  • 35
0
votes
3 answers

Call a stored procedure after a configurable amount of hours after an insert

I am using SQL Server 2008 Express and I cannot buy the full version it is not in the budget. What I need is after an insert is done to call a stored procedure to send a notification email after a certain amount of hours. This amount of hours is…
user758105
  • 77
  • 1
  • 7
1 2 3
…
22 23