Questions tagged [express-edition]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
3answers
39 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 ...
1
vote
1answer
15 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 ...
2
votes
1answer
73 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 ...
0
votes
4answers
206 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,...
1
vote
1answer
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 ...
2
votes
1answer
7k 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 ...
7
votes
2answers
14k 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 ...
0
votes
1answer
616 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 ...
1
vote
1answer
1k 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 ...
0
votes
0answers
434 views

Install 10g XE on 64bit linux

As I know there is only 32bit version of 10g XE, am I right? And the installation file is called "oracle-xe-univ-10.2.0.1-1.0.i386.rpm". I want to install it on Centos 6.4 64bit. But during the ...
4
votes
2answers
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:...
0
votes
1answer
740 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 ...
3
votes
2answers
4k 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 ...
6
votes
1answer
678 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 ...
4
votes
2answers
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 ...
1
vote
2answers
454 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 ...
19
votes
4answers
10k 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 ...
2
votes
2answers
199 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?
4
votes
3answers
588 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 ...