Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [express-edition]

20 questions
19
votes
4 answers

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 Express Edition lacks SQL Agent. What approach would…
rem
  • 1,555
  • 3
  • 20
  • 22
7
votes
2 answers

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) 2017 Microsoft Corporation Express Edition…
Lucas Rasolofoniaina
  • 103
  • 1
  • 9
7
votes
2 answers

SQL Server Express vs. Oracle Express Edition vs DB2 Express-C

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 differences as this is a constantly shifting battle…
Lucas
  • 369
  • 2
  • 5
  • 15
6
votes
1 answer

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 - I'd like to keep everything as simple as…
Jack Douglas
  • 40,517
  • 16
  • 106
  • 178
4
votes
3 answers

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 more than 10 CRUDs, and won't have a high data…
Smur
  • 244
  • 1
  • 2
  • 8
4
votes
2 answers

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 to a degree, but seemed to try and import views as…
Jack Douglas
  • 40,517
  • 16
  • 106
  • 178
4
votes
2 answers

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: D:\DB2\scripts>db2pd -dbptnmem Database Member…
Lucas
  • 369
  • 2
  • 5
  • 15
3
votes
1 answer

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 here, possibly because it doesn't exist.
SQLDoug
  • 247
  • 3
  • 7
3
votes
2 answers

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 they valid for Express and what about SQL CE4? The…
Daniel
  • 297
  • 2
  • 5
  • 10
2
votes
1 answer

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 install SQL Server 2012 Express from the full…
Kevin
  • 21
  • 1
  • 3
2
votes
2 answers

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
  • 169
  • 2
  • 10
1
vote
2 answers

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 this with the profiler in 2000 (not sure)? However…
Jack Douglas
  • 40,517
  • 16
  • 106
  • 178
1
vote
1 answer

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 to unlock, grant connect and resource privileges…
Rajan
  • 111
  • 3
1
vote
1 answer

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 engineer, the error was cleared. I couldn't check…
RGO
  • 423
  • 6
  • 13
1
vote
1 answer

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 answer? Anyone know if this is possible and if so,…
TattooedDBA
  • 153
  • 2
  • 10
1
2