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

Crystal Reports XI + VB.NET 2008

I'm using VB.NET 2008 Professional with Crystal Reports Professional XI and with MSSQL Server 2008 Express. I've tried already to build a database with/or SQLDataReader and/or DataSet and use it with the Report Viewer, but it is not working…
victorwestmann
  • 173
  • 1
  • 12
1
vote
1 answer

Visual studio express is too hanging when building the source code

I am using Visual Web Developer 2010 Express in my PC for building an MVC 3 application. it's working fine till I installed Sql Server 2008 Management Studio yesterday. After I installed the SSMS my Visual Web Developer is hanging when I Build my…
Ragesh P Raju
  • 3,879
  • 14
  • 101
  • 136
1
vote
0 answers

Application display error after windows upgrade

Hi I have recently upgraded from windows 7 to windows 8.And have installed both Visual studio 2010 and 2012 on my PC.I had two personal application that worked fine under windows 7 but after trying to run them on windows 8 I get the following…
aleczandru
  • 5,319
  • 15
  • 62
  • 112
1
vote
0 answers

Microsoft SQL Server 2008 Express decreasing memory usage

I have a virtual machine running windows 2008 standard R2 sp1 and Forefront TMG 2010. TMG 2010 also installs SQL Server 2008 Express for logging activities. According to perfmon SQL Server Express is using about 1 gb of ram. I have tried to decrease…
imperio
  • 11
  • 2
1
vote
0 answers

C# Application with SQL Server install

I am trying to install my C# application on a VMWare machine with Windows Vista, the PC is completely clean. The install works fine except for the last part, when SQL Server 2008 Express is trying to install, after that, a batch, converted to an…
Max
  • 12,622
  • 16
  • 73
  • 101
1
vote
1 answer

Data is not inserted in database

String nam = name.Text; SqlConnection cn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\test.mdf;Integrated Security=True;User Instance=True"); SqlCommand cmd = new SqlCommand("INSERT INTO tab(tname)VALUES(@val)",…
user1782089
  • 11
  • 1
1
vote
2 answers

Cannot create Sql Server database in App_Data folder

When I try to create an Sql Server Database in the App_Data folder of my Visual Studio 2010 project, I get the following error: Login failed for user:[Domain]\[user] I am able to create databases using Sql Server Management Studio. I am using Sql…
ankit0311
  • 735
  • 3
  • 10
  • 20
1
vote
1 answer

How to handle mass email alert system for a registered userbase

I have a client who would like a system developed which handles sending out alert emails to opted-in registered users. The alerts are based on geographic travel-related incidents and these are provided via a third party web service. The registered…
Mel Lota
  • 75
  • 7
1
vote
2 answers

How to calculate SQL dates based on pilot's birthday as well as current date

So, pilots have to get so many flight hours and flight sorties within every 6 months (semi annual) as well as every year (annual). The biggest pain is that the start and ending dates of these periods are based upon their birth month. You can find…
user114518
1
vote
1 answer

Relative path connection string vb.net

Possible Duplicate: SQL Express Connection string - Relative to application location I have a desktop application written in vb.net. The app uses an SQL Server express 2008 database (.mdf file). Currently i have the connection string as absolute…
Pantheo
  • 129
  • 1
  • 8
  • 15
1
vote
2 answers

Select next row

I would like to concatenate two text fields from the current row with the same field from the next row So if the table is like field1 field2 field3 text1 text3 order1 text2 text4 order1 i would like to do this: if (field3.current_row =…
jorrebor
  • 2,166
  • 12
  • 48
  • 74
0
votes
1 answer

ADO SQL Server, "Method 'Open' of object '_Connection' failed"

(Tearing my hair out, been doing this a million times for decades and now it doesn't work!) I have a simple VB6 program, connecting to SQL 2008 Express locally on the host machine. I can connect to the database using the same credentials in SQL…
Jay Imerman
  • 4,475
  • 6
  • 40
  • 55
0
votes
1 answer

Enabling remote connection to SQL Server 2008 Express on Windows Server 2008

I am trying to connect to the SQL Server 2008 Express from my local machine but for some reasons I am not able to connect to the server. sqlserver.exe is allowed in the firewall TCP protocol is enabled sqlexpress is running allowing remote…
Nag Bandla
  • 56
  • 2
  • 13
0
votes
1 answer

A good summary/explanation of Sql Server Express 2008 versions available for download?

Can someone tell me whether this link that I used to install Sql Server Express 2008 is version R2 or not? I installed from here: http://www.microsoft.com/download/en/details.aspx?id=22973 The reason that I ask is that I am trying to setup an…
BruceHill
  • 6,954
  • 8
  • 62
  • 114
0
votes
3 answers

Updates to Records not allowed - Write Conflict

This stems from a previous question I asked - about a write conflict with a form, but the problem seems to be originating from the fact that I can update existing records in a linked table provided by one System DSN, but not another linked table…
Comrad_Durandal
  • 651
  • 2
  • 10
  • 23
1 2 3
…
22 23