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

Failing to connect to MSSQLSERVER

I've installed SQL Server 2012 Express. The problem is that I cannot connect to it through MSQL Server Management Studio. When installing it, I've used MSSQLSERVER as an instance name. I have SQL 2017 running as SQLEXPRESS. Checking at the services,…
Dino
  • 7,779
  • 12
  • 46
  • 85
1
vote
3 answers

How to prevent updating certain rows in SQL Server 2012?

I'm trying to perform a query that will unable the user to update certain rows with a condition. I know this is done by trigger but I'm still a beginner and I don't know how and how to activate or call that trigger in c# windows forms. This is my…
Danger Zone
  • 59
  • 1
  • 10
1
vote
0 answers

Values not updating but showing rows affected

THERE IS NO TRIGGER ON THIS TABLE. I'm facing strange behaviour of sql server. One of the table column value not updating. Here is the query and output: Now if I execute the update statement, it executes successfully: As per update statement all…
Jakir Hossain
  • 91
  • 1
  • 7
1
vote
2 answers

Displaying yearly totals in ListView control

I am testing a sample application, which adds a number of individuals i.e., "people" and records a measure of time for each month of the year for each of these people i.e., "minTime" a decimal value, and "auxTime" a decimal value. In my code, I…
CodeMann
  • 157
  • 9
1
vote
2 answers

SQL Server database connection broken after a forced computer shutdown

My application uses SQL Server 2012 Express and an .mdf database to store data. Sometimes the end-user shuts down Windows and the computer (tablet) by keeping the power button pressed for 5 seconds. This is done while my application is still…
user9876051
1
vote
2 answers

Concat cells of multiple rows into one row

I have a really weird requirement for my SQL Server table and I'm not sure if it is impossible to solve. I have a client-side grid/table which displays data by a given T-SQL query/stored procedure. The table in the SQL Server database that I am…
woodyplz
  • 13
  • 1
  • 6
1
vote
2 answers

T-SQL select all IDs that have value A and B

I'm trying to find all IDs in TableA that are mentioned by a set of records in TableB and that set if defined in Table C. I've come so far to the point where a set of INNER JOIN provide me with the following result: TableA.ID |…
Cyspoz
  • 13
  • 3
1
vote
1 answer

SQL Server 2012: cannot import data from MS Access due to FOREIGN KEY Contraint

I use the import wizard for importing data from Access 2010 database into SQL Server tables. I try to import from tblMembers which includes the most important column MiID, which is used as a FK in different other tables. It seems that in the Access…
mak
  • 359
  • 3
  • 14
1
vote
0 answers

Restoring only structure/schema from .bak file in SQL Server 2012 Express

Please assist me, how to restore .bak file in SQL Server 2012 Express with a size of more than 10GB. Checked on google, found third party tool idera sql safe, through which we can restore part of the .bak file, i.e. only schema /structure, but don't…
LN Charan
  • 11
  • 1
  • 4
1
vote
1 answer

Cannot get data from SQL Server 2012

When I try to login to my website, an error occurs. I tried with run the SQL Service too. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify…
cain
  • 709
  • 2
  • 10
  • 18
1
vote
1 answer

Why in SQL Server 2012 some local groups are missing

During installation of SQL Server 2008, the following three local groups are automatically created where SQLEXPRESS is the instance name. SQLServer2005SQLBrowserUser$ SQLServerMSSQLServerADHelperUser$ …
AyrtonSenna
  • 79
  • 11
1
vote
0 answers

How do I access my sql server 2014 express adv from another computer?

Cannot connect to ITADMIN\SQL2014. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct…
sujith Augustine
  • 11
  • 1
1
vote
1 answer

SQL Server 2012/2014 Express setup.exe fails on WS2012 R2 when run in quiet mode

I downloaded SQLEXPR_x64_ENU.exe and extracted its content (/X option) into a temp folder. I then attempted to run setup.exe in a quiet mode. Unfortunately the setup failed. Here is the command line that I used to install the server and the output…
bdristan
  • 1,048
  • 1
  • 12
  • 36
1
vote
1 answer

How to enable File Streaming in existing SQL Server database

I am saving all documents in the database in the form of binary but the main issue is day by day my database size increasing because of users documents. So someone suggested to enable "File streaming" in your database. Suggest some solution.
sachin bhatt
  • 57
  • 4
1
vote
2 answers

Trigger to log inserted/updated/deleted values SQL Server 2012

I'm using SQL Server 2012 Express and since I'm really used to PL/SQL it's a little hard to find some answers to my T-SQL questions. What I have: about 7 tables with distinct columns and an additional one for logging inserted/updated/deleted values…
mrbTT
  • 1,399
  • 1
  • 18
  • 31
1 2 3
…
26 27