Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-express]

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

The Microsoft® SQL Server® Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft's System Preparation Utility for Microsoft Windows operating system deployment.

Source: Microsoft (SQL Server 2012 Express)

401 questions
2
votes
2 answers

SQL Server 2012 Express version in registry

I have an installation code which checks the version of the SQL Server installed by reading the version number from the registry key SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion -> current version. I installed SQL Server 2012 Express…
yaronkl
  • 510
  • 2
  • 5
  • 18
2
votes
0 answers

SQL Server 2012 Unattended Installation

I am trying to install SQL Server 2012 Express from command line. Here is a test example: setup.exe /QS /ACTION=install /INSTANCENAME="UnattendedCmd123" /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLENGINE,SSMS …
FrostyFire
  • 3,212
  • 3
  • 29
  • 53
2
votes
1 answer

Can I reuse database file of localdb in Express editions

I am going to build a small application and like to use SQL Server LocalDB, but I'm confused about some points When I start my instance and shared it in main PC and connecting to my database, does anyone on my local network can see this…
Hasan Yusuf
  • 33
  • 3
2
votes
3 answers

Can't get rid off "Login failed for user IIS APPPOOL\NETWORKSERVICE"

I'm trying to access a sql server database from an ASP NET app configured to work with IIS. I have several questions now, 1) Authentication in IIS: I need to know if my authentication settings for the site are ok: I tried with Windows…
Rafael
  • 2,413
  • 4
  • 32
  • 54
2
votes
2 answers

Code First or Model First

I'm about to develop some LOB applications using VS2012, WPF, Sql Server Express 2012, Unity, Prism. I don't have legacy applications to care about. Is it ok if I choose the Model First workflow for my upcoming projects, are there some important…
Rafael
  • 2,413
  • 4
  • 32
  • 54
2
votes
1 answer

SQL Server Browser - Startup Type - Best Practice

During the installation of SQL Server Express 2012 on a new machine, I am able to specify the startup type of both the SQL Server Database Engine and the SQL Server Browser. By default, the SQL Server Database Engine has a Startup Type specified as…
sthede
  • 914
  • 1
  • 8
  • 27
2
votes
3 answers

How do I get values for all months in T-SQL

I have a query that I would like to display all months for the year regardless if they have sales for that month or not. I know the issue is with the Group By, but how do I change the query so I don't need it? SELECT ISNULL(MONTH(sd.SBINDT),0)…
tsqln00b
  • 355
  • 1
  • 4
  • 20
2
votes
2 answers

Issue when deploying an ASP.NET MVC + LocalDB application

I have deployed my ASP.NET MVC 5 application on a server but it crashes on every page using the localdb. Yet I copied the App_Data folder where the .mdf file is located. And I even installed SQL Server 2012 Express on the machine. Nevertheless every…
Serge
  • 6,554
  • 5
  • 30
  • 56
2
votes
1 answer

one sql trigger insert,update,delete for all tables in the database

is it possible to declare one Sql Trigger Insert, Update, Delete for all tables in the database instead of creating a separate trigger for each table? I just want a simple history of what actions have been taken e.g. TABLE A deletes a row ,TABLE B…
Stelios
  • 330
  • 5
  • 21
2
votes
1 answer

Auto-increment my primary key SQL Server 2012

I'm using SQL Server 2012, I want to add an auto-increment to my primary key I don't know the exact syntax so i tried this but it obviously won't work ! Help please !!! ALTER TABLE dbo.Equipe alter numero_equipe add IDENTITY(9999,1)
white mind
  • 45
  • 6
2
votes
1 answer

I can't restore database from .bak file in SQL Server 2012

When I select the .bak file it is nothing shown in the 'backup sets to restore' area below. This is the newest backup version from hosting server 2012. If I try restore a few months older .bak file from the same hosting server it works fine. I am…
user2758885
  • 21
  • 2
2
votes
1 answer

Lightswitch can't connect to the database on local development (VS 2012)

I have LightSwitch installed in VS 2012. I have SQL Server 2012 Express with LocalDB installed on my machine. I created a new project, add new table, and when I run the project I get the following error: An error occurred while establishing a…
SexyMF
  • 10,657
  • 33
  • 102
  • 206
2
votes
1 answer

SQL Server Express 2012 Installation fails with Could not find the Database Engine startup handle in SQL Server Express 2012

I have recently done a fresh installation of my work machine. I installed Windows on drive C: but my Users folder is on drive D:. After trying to install SQL Server 2012 Express, I always got errors that said Could not find the Database Engine…
LeonidasFett
  • 3,052
  • 4
  • 46
  • 76
2
votes
1 answer

CREATE MASTER KEY - Password validation failed

logged in as 'sa' in MS sql server management studio, when I try execute as login='sa' CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'S0URCE_DB KEY Pa$$W0rd' it always takes more than 1 minute to get this error message, whatever kind of password I…
jean-hugues
  • 31
  • 3
2
votes
1 answer

how to insert value in image datatype table

I am using Sql-Server 2012. In it i made a column named Image with datatype image in Person table. Please explain that how can i add value in it? I mean should i have to define a path of any photo? or is there any other way to insert images in this…
Dua Ali
  • 3,163
  • 3
  • 19
  • 13
1 2 3
…
26 27