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
5
votes
1 answer

Master table node missing , SQL Server 2012 SP1

I've installed Microsoft SQL Server 2012 Express with SP1 (with all the "Cumulative Update #6 for SQL Server 2012 SP1") Can't view any "table node" on System database under “master” in the Management Studio. Note : there is a post here that point to…
userbattaglia7
  • 51
  • 2
5
votes
2 answers

Auto-computed column in SQL Server 2012

Is it possible for a column in to be auto-calculated by SQL Server 2012 itself? For example: I have three columns START_DATE, END_DATE and DURATION. I want to get the duration by doing this : DURATION = END_DATE - START_DATE So I get the duration…
Brian
  • 1,951
  • 16
  • 56
  • 101
4
votes
0 answers

Database Schema Compare : Published Script Without Command Mode

My question is regarding to SQL schema compare. Database Schema Compare When i generate script using SQL schema compare, script is generating in below format. /* Deployment script for Student This code was generated by a tool. Changes to this file…
yogesh
  • 45
  • 1
  • 8
4
votes
2 answers

SQL Server database new schema using VB.NET

Using VB.NET, I successfully created a new database and imported data into a table from an Excel file into a SQL Server 2012 Express database. The new table is created with the default schema dbo. I would like to create a new schema for the…
CadSquad
  • 39
  • 4
4
votes
1 answer

how to deploye C# windows form application developed with sql server express 2012 and crystal report

I have developed an application in Microsoft Visual Studio 2013. .Net framework 4.5. DBMS i used is sql server 2012 express and for reporting is used Crystal report 13 I want to Create a setup file which can install .net framework, sql server and…
Haider Ali Wajihi
  • 2,756
  • 7
  • 51
  • 82
4
votes
3 answers

SQL Server - Same table in multiple schemas

I am creating a smaller sized database in Microsoft SQL Server 2012 to keep run data from machines. The company has production machines and R & D machines. I would like to use the same table for production and R&D with a Type field specifying what…
user3711685
  • 71
  • 2
  • 4
4
votes
1 answer

How to select all dates from 2002 to 2013 in Microsoft Sql Server 2012

I have found this solution, but it is limited to 2047 days. DECLARE @MinDate DATE, @MaxDate DATE; SELECT DATEADD(DAY,number,@MinDate) [Date] FROM master.dbo.spt_values WHERE type = 'P' AND number > 0 AND DATEADD(DAY,number,@MinDate)…
Yegor Razumovsky
  • 902
  • 2
  • 9
  • 26
4
votes
2 answers

Silent Install of SQL Server Express 2012 from Inno Setup

I am trying to install SQL Server Express 2012 silently from my application installer created using Inno Setup. When running the following command from the command line, SQL Server Express 2012 is installed as I want only showing progress of the…
JasonMcF
  • 632
  • 8
  • 18
4
votes
1 answer

Create filtered index not working in SQL Server 2012 Express

I'm trying to create a filtered non-clustered index. In the gui I right-click the Indexes folder of the table where I want the index. Add the column where the index should be applied, then click on the filter page to add this statement: WHERE eMail…
Craig Smith
  • 583
  • 3
  • 9
  • 26
4
votes
2 answers

Sending a DataTable as a parameter to stored procedure

I'm trying to send a DataTable to a stored procedure using c#, .net 2.0 and SQLServer 2012 Express. This is roughly what I'm doing: //define the DataTable var accountIdTable = new DataTable("[dbo].[TypeAccountIdTable]"); …
Asaf Sitner
  • 599
  • 1
  • 10
  • 18
4
votes
3 answers

How do I prevent other applications from connecting to SQL Server?

I have a Delphi application connecting to a remote SQL Server via ADO components. How can I allow only my application access to SQL Server 2012 and any other application trying to connect should be thrown out?
user819783
  • 61
  • 1
4
votes
3 answers

Installed SQL server management studio 2012, but there are no instances running

So, as it says, I installed sql server (2012 express), and during installation I checked the option LocalDB. Now I'm trying to connect to the database engine, but can't. I've tried connecting with windows authentication (to local, and localhost),…
stinaq
  • 1,274
  • 3
  • 19
  • 31
3
votes
2 answers

Connection string format and SQL Server login error

This is my first "code first approach" with SQL Server 2012 Express. I'm trying to create a database but there is a problem with the connection string. This is my connection string: Data Source=AMBROGIO\SQLEXPRESS;Initial…
Pickeroll
  • 908
  • 2
  • 10
  • 25
3
votes
1 answer

SQL Primary Key Exception

I have a Mircrosoft Sql Server database made up of about 8 tables that are all related that I am trying to update. To do this I create a number of temporary tables "CREATE TABLE [vehicle_data].[dbo].[temp_MAINTENANCE_EVENT] (" + …
nastassiar
  • 1,545
  • 2
  • 24
  • 43
3
votes
1 answer

Update existing table with query results SQL Server 2012

I am attempting to add the result of my query into the column of an existing table. Thus far the query below finds the nearest electric substation within 30 kms of an electric line. Select el1.id, el1.geog4269.STAsText(), (Select TOP 1…
elseflyer
  • 33
  • 4
1 2
3
…
26 27