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
1
vote
1 answer

Create failed for database 'ToDoList'. (Microsoft.sqlserver.smo)

I am trying to create a database using SQL server Management Studio 2012. But on clicking the create database,i am getting an error: A file activation error occurred. The physical file name 'ToDoList.mdf' may be incorrect. Diagnose and correct…
reeversedev
  • 382
  • 1
  • 3
  • 18
1
vote
2 answers

Duplicates in Union

I'm new to SQL so this is probably why there is an issue with my query but my problem is that I run the below query and end up with many duplicates on my table. Both tables have a list of items with the same stock numbers which is why I'm joining…
Andy00001
  • 87
  • 2
  • 9
1
vote
0 answers

How to combine 4 or more tables with different joins, avoiding some minor duplication

I'm trying to build a query for combining 4 of my tables into a pre-created table, my query was running smoothly for the first 3 tables. Here is my query (*query and tables are already simplified) INSERT INTO goaltable SELECT b.employeeID,…
Joe Adventa
  • 13
  • 1
  • 6
1
vote
1 answer

Querying SQL Server to obtain sum total using CTE and joins

I have a below query that I am trying since yesterday with some 33 records of Employee with employeeId on various conditions: With CTE ( select EmployeeId, and other colums with joins and conditions. ) Now I want to join this query to obtain…
Sweetie
  • 1,298
  • 6
  • 24
  • 48
1
vote
1 answer

Interest Calculation By Date

I am now in a very tricky situation. Using MSSQL 2012 Express. I have a voucher table from which I am retrieving following details for PARTY A for example. In following query result, I am getting all details successfully except last column…
Hemal
  • 3,682
  • 1
  • 23
  • 54
1
vote
0 answers

Get Open SqlConnection/SqlDataReader objects in code

I am developing a Web Application using ASP.NET 4/VB.NET with web forms and using MS SQL Server 2012 Express Advanced Edition as back end. My application is huge and there are so many lines of code which contains SqlDataReaders and SqlConnection…
Hemal
  • 3,682
  • 1
  • 23
  • 54
1
vote
0 answers

In SQL Server 2012 does a wildcard search of '%text%' use the index?

In SQL Server 2012 does a wildcard search of '%text%' use the index? I read that in MySQL it doesn't.
sharpie
  • 21
  • 2
1
vote
0 answers

Cannot connect to SQL Server - what's wrong?

I installed Microsoft SQL Server 2012 Express Management Studio with Service Pack 1 32/64 bit. When I try to connect I get the following error: Have I installed/done something wrong? Because I cannot see anything in SQL Server Services: Please,…
Jena
  • 11
  • 2
1
vote
1 answer

update table in short way

I have states table and stores 56 states and IDs, and I am updating my value column in FieldValue table based on those ID stored in [Cases] table. I can use case statement to get the result, I don't want to repeat case statement 56 times Update cv…
er ser
  • 41
  • 1
  • 1
  • 6
1
vote
1 answer

"Login failed for user" trying to connect to SQL Server 2012

I'm trying to get acces to a remote SQL Server, using SDAC. (in fact I have to get access to the remote DB from android application) What I've done to set up is here The configuration string of the TMSConnection is: Password=mysaPwd;Data…
Gianluca Colombo
  • 717
  • 17
  • 38
1
vote
0 answers

Datatype to Store and Retrieve HTML from sql server express 2012?

I am using Jquery Text editor by using which I have to store and retrieve HTML including images from database, Is it possible to do or is it something silly to ask?? Just wondering if various CMS's are providing this functionality then it might be…
Learner
  • 776
  • 6
  • 14
  • 40
1
vote
0 answers

SQL Server 2012 Express Command Line install

I am trying to install SQL Server 2012 Express SP1 via the command line, however it just quietly fails, no error messages. Can anyone help? Here are the commands I'm using. c:\>sqlexpr32_x86_enu.exe /QS /IACCEPTSQLSERVERLICENSETERMS …
Chris Bahr
  • 90
  • 2
  • 7
1
vote
1 answer

How to create tables to maintain users family relation?

I am working on a "family dictionary" project. I am creating tables in sql server. I am planning to give permission to user to create family, but I can't trust user. He/She can create multiple families. What is the way to maintain unique family in…
Ashish-BeJovial
  • 1,829
  • 3
  • 38
  • 62
1
vote
2 answers

SQL Server Express connection string error

Trying to figure out the correct connection string for a SQL Server Express database. Trying to publish my app to IIS and test before publishing to my hosting site. A network-related or instance-specific error occurred while establishing a…
Troy Bryant
  • 994
  • 8
  • 29
  • 60
1
vote
1 answer

Install SQL Server 2012 Express Programmatically

I work on Setup application to install all requirement for my WPF product, one of the requirement is SQL Server 2012 Express, the code below is to install it after I generate the configuration file for silent installation : private void…
Abdulsalam Elsharif
  • 4,773
  • 7
  • 32
  • 66
1 2 3
…
26 27