All Questions
Tagged with sql-server-express sql-server-2012
16 questions
2
votes
2
answers
2k
views
Cannot find Database Mail feature in SQL Server Express 2012 SP1
I need to use SQL Server Database Mail feature in my project. However Database Mail seems not available on my development instance.
There should be a 'Database Mail' node in the Object Explorer. In ...
- 131
0
votes
0
answers
78
views
Migrating SQL Server 2012 Web Edition to Azure
I am trying to migrate to Azure I have gone through this article Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS, However since I am having SQL Server ...
2
votes
2
answers
5k
views
Express edition core limits ambiguity
We have an application that uses MSSync to download data from a server into a client's SQL Server Express 2005. The client's have a dual core with hyperthreading so, a total result of 4 cores.
I have ...
- 123
1
vote
1
answer
173
views
microsoft sql express 2012 authentication connection issues - can't login
I am a novice when it comes to Windows networking authentication, as well as just getting my feet wet with SQL Express, so please bear with me, hopefully this is a simple fix but so far the obvious ...
- 121
1
vote
0
answers
44
views
Installing SQL Server Express from SQL Server Developer Installer
If I install SQL Server 2012 Express using the SQL Server 2012 developer installer, do I still have access to all features available from the Advanced Services and/or With Tools versions of SQL Server ...
- 83
1
vote
1
answer
4k
views
Automate backup using Windows Task Scheduler
I want to run an automatic backup of SQL Server 2012 Express using Windows Task Scheduler.
I have 3 user databases. I want to backup all 3 user databases through a single stored procedure and a ...
- 6,497
1
vote
3
answers
16k
views
Cannot install database engine services, replication and SQL writer
I am trying to install SQL Server 2012 Express, but I get this error (I try to uninstall and delete registry key, try to change account for database engine to NT Authority\System, but reinstall still ...
- 19
5
votes
1
answer
15k
views
How many users are supported on SQL Server 2012 Express?
I would like to say that i have gone through some of the sql blog and MSDN BOL, but still there is some confusion in mind like.
The limitation of SQL Server 2012 Express is 10 GB. It is the ...
- 6,497
2
votes
3
answers
12k
views
SQL Server express - Management studio installation hangs at native images installation
I've been trying to install SQL server express edition (2014) with management studio and consistently failing to do so because installation stalls at step 'Install_sql_common_core_Cpu64_Action : ...
- 185
1
vote
2
answers
814
views
Feature of database-level audit in SQL Server 2012 Express edition
Like in SQL Server 2012 Enterprise edition, can we have database-level audit in SQL Server 2012 Express edition?
Can we have Audit Folder in Security Tab?
Bunzitop
0
votes
1
answer
3k
views
SQL Server Express 2012 Repair
I have a copy of SQL server Express 2012 database which may be corrupt. When I tried to run a repair on it I was asked for the original installation media. The Options were for an MSI or ISO image. ...
- 101
0
votes
1
answer
229
views
SQL Server 2012 Express SP1 install still not 11.1
I run the SQL Server 2012 Express SP1 install and it succeeds. After I have rebooted my computer, I do a
select @@version
But still I only have version 11.0.21600.64. I have tried this on two ...
- 133
2
votes
3
answers
12k
views
Inserting Serbian Latin and Cyrillic characters
I am using SQL Server 2012 Express as part of my asp.net development workstation. Database and table collation is set to Latin1_General_CI_AI. Attribute types are nvarchar(max) and varchar(max).
...
- 155
4
votes
1
answer
1k
views
Why clustered index scan?
I just started to learn to optimize my queries and to analyze their query plans. I thought this query would generate nonclustered index seek + key lookup.
SELECT ct.*
FROM Person.ContactType AS ct
...
- 143
22
votes
1
answer
26k
views
Why does SQL Server 2012 Express use 9.5GB of RAM on my server?
I am building an application in which I plan to embed SQL Server 2012 Express as the primary datastore. When testing on my development machine (Win7-32 with 3GB RAM), I never observed the sqlservr....
- 535
0
votes
2
answers
117
views
Mark exported rows as exported
I need to write an export module which marks exported rows as exported.
We currently run SQL Server Express 2012, but may switch to Oracle, so I need
a client-side approach. We are currently using ASP....
user10519