Skip to main content

Questions tagged [express-edition]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
193 views

SQL Server 2016: Table can't grow while 313 MB is still available in the database

Yesterday, the below error was reported: Could not allocated space for object 'dbo.X'.'Y' in database 'Z' because the 'PRIMARY' filegroup is full After deletion of some records from the table by an ...
RGO's user avatar
  • 423
7 votes
2 answers
1k views

AlwaysOn High Availability doesn't work , can't activate it

I am trying to activate the high availability on my SQL server and getting below message: SQL server version: Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) ...
Lucas Rasolofoniaina's user avatar
0 votes
3 answers
782 views

Always Encrypted on Sql 2017 Express Edition

I am so tentative to decide to use Always Encrypted tool, however I have a question → I'm working on a project with SQL Server 2017 - 14 Express Edition. And I'm pretty sure they aren't going to buy ...
Roger Ospina's user avatar
1 vote
1 answer
171 views

Is it possible to install a service pack to a SQL 2012 Express instance?

I have a SQL 2012 Express instance that is on Service Pack 3. I am trying to find a way to update it to Service Pack 4 but this doesn't seem to be possible or maybe I am just not finding the right ...
TattooedDBA's user avatar
0 votes
4 answers
2k views

SQL Server 2017 Express faster than Standard Edition [closed]

What could explain SQL Server Express Edition being much faster than Web / Standard Edition? These are multiple VMs in cloud hosting. They all experience the same problem. Some are on SQL Server 2012,...
Lambda's user avatar
  • 101
3 votes
1 answer
4k views

Is there an Express version of Azure SQL DB?

With on-premise SQL Server, there are editions such as Express, Web, Standard, and Enterprise. Do those editions (or an analog) exist in Azure SQL DB, especially Express? My Google-Fu is failing ...
SQLDoug's user avatar
  • 237
2 votes
1 answer
8k views

How to do unattended install of SQL Server 2012 Express from the Enterprise media?

I have a requirement to install SQL Server 2012 Express on some machines, and SQL Server Enterprise on some others, and I'm attempting to avoid using separate packages to do so. It's pretty simple to ...
Kevin's user avatar
  • 21
0 votes
1 answer
819 views

Oracle 11g not allowing to connect to. Error ORA-01122: database file 1 failed verification check

I am running Oracle 11g on Windows 7 Enterprise SP2 16 GB RAM, 1 TB HD. I can connect to Oracle using SQL Plus (see below), C:>sqlplus sys/xxxxxxxxx@XE as sysdba SQL*Plus: Release 11.2.0.1.0 ...
user_dhrn's user avatar
  • 101
1 vote
1 answer
2k views

ORA-12541 error while connecting to oracle express edition 11g

My oracle express edition was working some months earlier. I dont know what i changed in the system, now I could not connect to it. I tried logging in from sqlplus as sysdba and altered the accounts ...
Rajan's user avatar
  • 111
0 votes
1 answer
840 views

READ_COMMITTED_SNAPSHOT support in SQL Server 2005 Express

I wonder if SSE 2005 supports the READ_COMMITTED_SNAPSHOT database option. What I found is this article: Features Supported by the Editions of SQL Server 2005. It states that SSE 2005 supports ...
Gopher's user avatar
  • 135
4 votes
2 answers
2k views

Memory limitations on db2 express-c version 10.1 seems stuck at 2 gig, why?

I just updated from 9.7 to 10.1, to leverage the new 4gig memory limitation. However, my app only appears to be using 2. So i searched for a way to find out how memory is used and found this command:...
Lucas's user avatar
  • 369
7 votes
2 answers
15k views

SQL Server Express vs. Oracle Express Edition vs DB2 Express-C [closed]

I have been trying to compare the features of the SQL Server Express, Oracle XE and DB2 Express-C, but find it difficult to compile all the differences into one place. Especially the current ...
Lucas's user avatar
  • 369
1 vote
1 answer
136 views

Requirement of SQL Server 2008

The software I am installing requires SQL Server 2008. I have SQL Server 2008 R2 Express Version. I am having problem in the setup and finally I am arriving on the conclusion that my SQL Express can ...
TheTechGuy's user avatar
3 votes
2 answers
5k views

Max number of tables (objects) in SQL Server editions (compact, express)

What are the maximum number of tables that you can have in: SQL CE4 SQL 2008 R2 Express Numbers here http://msdn.microsoft.com/en-us/library/ms143432.aspx I guess is for SQL Server 2008, but are ...
Daniel's user avatar
  • 297
1 vote
2 answers
460 views

How do I record SQL transactions with SQL Server Express

With a test migration from 2000 to 2008R2 Express, one function from the client application fails silently. I'd like to find out what SQL is running and why it fails. I think I would have attacked ...
Jack Douglas's user avatar
2 votes
2 answers
225 views

Is it fine to run a public website on the sql express db?

Is it fine to run a public high traffic website on a sql server 2008 express db?
Amr Elgarhy's user avatar
4 votes
3 answers
592 views

Usage of SQL Server 2008 R2 Express. Please Advise

I'd like you all to give me hints and advise on the following scenario: We are considering using Microsoft's SQL Server 2008 R2 Express for a business Web Application. The Web Application won't have ...
Smur's user avatar
  • 244
4 votes
2 answers
7k views

How to migrate from SQL Server 2000 to SQL Server 2008 R2 Express Edition

I have been trying to migrate a database from SQL Server 2000 (part of SBS 2003) to SQL Server 2008 R2 Express Edition I naively tried using the SQL Server Export and Import wizard. This has worked ...
Jack Douglas's user avatar
6 votes
1 answer
703 views

How to back up a small database in SQL Server 2008 R2 Express Edition

I will shortly be migrating a database from SQL Server 2000 (part of SBS 2003) to SQL Server 2008 R2 Express Edition The database is small, and there are only a few hundred short transactions per day ...
Jack Douglas's user avatar
19 votes
4 answers
12k views

Task scheduler for SQL Server Express

I have an ASP.NET MVC app which works with database under SQL Server 2008 R2 Express edition. There is a need to perform a regular task on updating some records in the database. Unfortunately the ...
rem's user avatar
  • 1,555