The express-edition tag has no wiki summary.
0
votes
1answer
47 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 ...
2
votes
1answer
278 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 ...
4
votes
2answers
2k views
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 ...
3
votes
2answers
471 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 ...
0
votes
2answers
222 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 ...
2
votes
2answers
108 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
330 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 ...
3
votes
2answers
3k 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 ...
5
votes
1answer
469 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 ...
15
votes
4answers
7k 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 ...
