Stack Overflow
Stack Overflow

Questions tagged [sql-server-express]

Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.

1718 questions
6
votes
4 answers

How do I create a simple Windows form to access a SQL Server database?

I believe this is a very novice question, and if I'm using the wrong forum to ask, please advise. I have a basic understanding of databasing with MS SQL Server, and programming with C++ and C#. I'm trying to teach myself more by setting up my own…
NoCatharsis
  • 158
  • 1
  • 1
  • 4
6
votes
3 answers

Automatic fix for tempdb error related to 'ASPStateTempSessions'

As per this how-to, I've successfully configured IIS on my XP-SP3 dev box for SQL Server 2008 Express to save ASP.NET session state information. I'm just using SQL Server because otherwise on every recompile, I was losing the session state which was…
zanlok
  • 1,608
  • 1
  • 16
  • 29
6
votes
1 answer

No connection could be made because the target machine actively refused it TCP:0 Visual Studio

Im getting this error when i try to connect to SQL from a remote computer My firewall is disabled, my port is the default 1433, and is enable in the SQL Server Configuration Manager, also my IP on the router is enabled, and i dont use a any…
Mereszhka
  • 73
  • 1
  • 1
  • 6
6
votes
1 answer

SQL Server (SQLEXPRESS) and SQL Server Agent (SQLEXPRESS)

I came across these two services separately running in Services.msc - SQL Server (SQLEXPRESS) - started+Automatic SQL Server Agent (SQLEXPRESS) - Disabled Can you please guide why do we need SQL Server Agent (SQLEXPRESS)? Thank you!
inutan
  • 10,558
  • 27
  • 84
  • 126
6
votes
5 answers

OLAP on SQL Express

I'm wondering if there is any desktop OLAP solution that can use SQL Express (and therefore does not require Analysis Services) I've been tasked with finding a way to allow our customers to do 'Ad-Hoc' reports, but the vast majority of them are on…
stevenrcfox
  • 1,547
  • 1
  • 14
  • 37
6
votes
4 answers

How to fix MSSQLLocalDB?

On my machine MSSQLLocalDB got corrupted: PS C:\WINDOWS\system32> sqllocaldb i MSSQLLocalDB Projects ProjectsV12 v11.0 PS C:\WINDOWS\system32> sqllocaldb i mssqllocaldb The required LocalDB version "0.0" is not…
Andrew Savinykh
  • 25,351
  • 17
  • 103
  • 158
6
votes
4 answers

Silent Installation of SQl Express 2005

Can anyone please let me know the procedure to perform silent installation of SQL Server Express 2005 and the way to specify the installation parameters.
varsha
6
votes
4 answers

GO causes error when used in EXEC: "Incorrect syntax near 'GO'."

I've created this stored procedure which dynamically creates the same trigger for all my tables: USE [MyDatabase] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --Drop Stored Procedure BEGIN TRY DROP PROCEDURE…
Scott
  • 169
  • 1
  • 3
  • 14
6
votes
4 answers

How do you stop a user-instance of Sql Server? (Sql Express user instance database files locked, even after stopping Sql Express service)

When using SQL Server Express 2005's User Instance feature with a connection string like this:
Bittercoder
  • 11,753
  • 10
  • 58
  • 76
6
votes
3 answers

SQL server won't open DB created by Visual Studio

I've built an ASP.Net site in Visual Studio, and created the DB inside it (the .mdf file is in the APP_data folder). Now, when I want to deploy in the customer site, I think about maintaining the DB without open Visual Studio, and by using the SQL…
Roy Tsabari
  • 2,000
  • 6
  • 26
  • 41
6
votes
2 answers

Is there any performance difference between SQL Server Web and Express editions?

I have a VPS with Windows Server 2008 R2, 1 GB RAM with Dual Processor Quad Core 2 CORES. My sample application is running slower than my current website on shared hosting, when I asked the reason the says following reason: "SQL Server Express…
Sheo Narayan
  • 61
  • 1
  • 2
6
votes
2 answers

SQL Server query suddenly slow

I have a problem with a SQL database query that suddenly (but regularly about every three weeks) becomes slow. Setup is the following: Windows Server 2008 (not R2) 64 bit, 8 GB RAM SQL Server Express 2008 R2 The database has a size of 6 GB (mdf…
Slauma
  • 175,098
  • 59
  • 401
  • 420
6
votes
2 answers

Windows Azure VM (Iaas) unexpected restarts

I have a number of VMs on Windows Azure (Iaas) hosting a website. There are a number of load-balanced front-end VMs, all connecting to a single VM with SQL Express. It works well. However! I'm getting random restarts across all the VMs. As for the…
Gareth 'Kranzorg' Gauci
  • 116
  • 2
  • 5
6
votes
3 answers

SQL 2005 Express Edition - Install new instance

Looking for a way to programatically, or otherwise, add a new instance of SQL 2005 Express Edition to a system that already has an instance installed. Traditionally, you run Micrsoft's installer like I am in the command line below and it does the…
Douglas Anderson
  • 4,652
  • 10
  • 40
  • 49
6
votes
2 answers

Visual Studio 2012 Code First still uses SQLEXPRESS by default

I created a brand new Web API project, created a simple Code First model (one class with an id and the dbcontext object, and that's it), and ran Enable-Migrations in the package manager console. I noticed that it creates the database in SQLEXPRESS…
gzak
  • 3,908
  • 6
  • 33
  • 56
1 2 3
…
99 100