Stack Overflow
Stack Overflow

Questions tagged [sql-server-2014-express]

For questions specific to the scaled down, free edition of SQL Server 2014

Microsoft SQL Server 2014 Express is free and contains feature-rich editions of SQL Server that are ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.

The SQL Server 2014 Express release includes the full version of SQL Server 2014 Management Studio. For a complete list of supported features in SQL Server Management Studio, see Features in SQL Server Management Studio.

Source: Microsoft (SQL Server 2014 Express)

334 questions
1
vote
0 answers

SQL Server 2014 login failed

I have a remote connection problem. I can connect to SQL Server with Management Studio on my server. But when I try to connect remotely, it fails. The error is incorrect username or password I'm sure that's true.
Hakan Diril
  • 11
  • 1
1
vote
0 answers

Can the Visual Studio Data Compare tools synchronize filetable data

I have the need to sync schema and data between databases. I've used the Visual Studio SQL Server Compare tools to do this for many years. Recently i've started to play with Filetable tables, and need to sync these. The Schema compare is able to…
Sprintstar
  • 7,938
  • 5
  • 38
  • 51
1
vote
2 answers

Select those emails from db if they wanted to get an email

I am developing a system that heavily relies on emailing, I'm trying to determine if users wanted to get notified or not. User details are stored in SQL Server Express. I want to check which registered users wanted to receive and get their emails…
C.S.
  • 279
  • 1
  • 6
  • 21
1
vote
1 answer

SQL Server 2014 on Windows 10

I am trying to install SQL Server 2014 on Windows 10 but it requires .NET Framework 3.5 SP1. I have tried enabling the windows feature but for some reason this does not work on my machine. I then thought I would download a full version on .NET 3.5…
user2837961
  • 1,505
  • 3
  • 27
  • 67
1
vote
1 answer

How Do I Calculate A Running Total That Factors Both Date and Time?

I have been asked to create a stored procedure that displays rental item quantities across a variable date range. I have a table with the following schema: --Note that this is condensed, and in reality has proper constraints …
Zach Hardhat
  • 21
  • 7
1
vote
1 answer

How to add username and password in SQL Server 2014 Express database

How can I put username and password to my database mydb so that I can use it to my connection? Just like in MySQL we specify username = 'root' password = 'root'. I am using SQL Server 2014 Express.
jemz
  • 4,987
  • 18
  • 62
  • 102
1
vote
1 answer

SQL - Trending based on usage and month

I'm having a problem to create a trend based on data from database. I've tried by using this query; but multiple queries is needed. Besides, I would like to know if there any better practice to do this. SELECT DISTINCT TOP 1 billing.Accounts, …
Adrian Van Oyen
  • 33
  • 6
1
vote
1 answer

ETL - OLAP & OLTP - Maintain reporting and transnational Database in SQL Server 2014

My requirement is to maintain two database in SQL Server 2014 Management Studio (one for transaction and another for reporting) for single application developed in EF 7 and MVC 6. My question is what are the technologies I can implement for my…
Iswar
  • 2,211
  • 11
  • 40
  • 65
1
vote
4 answers

SQL Server 2014- can't connect to local db - can not find server

I just installed SQL Server 2014 Management Studio and when I tried to connect to my local db server, I get this message: What could be the problem, and what can I do to solve it?
Enass Hussien
  • 39
  • 1
  • 7
1
vote
2 answers

error getting in procedure

I am trying to build dynamic query for page compression, but at the time of execution it is showing an error. alter PROCEDURE usp_FindTableNameInAllDatabase @dbName VARCHAR(256) AS DECLARE @tableName VARCHAR(256) DECLARE @varSQL VARCHAR(512) DECLARE…
Sameer Sawant
  • 11
  • 2
1
vote
1 answer

ASP.net unable to UPDATE column in SQL Server

I'm creating an online application where I'm trying to update data through asp.net winforms. I have a textbox named tbCompanyName and a column in my database named companyName, in table tblCompanySetup. I'm SELECTING previous data from column…
Iqra Qureshi
  • 43
  • 8
1
vote
1 answer

Cannot connect to SQL Server 2014 via java

Question has been updated (The DriverManager is no longer loaded manually and instead the getConnection() method is used): package guii; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import…
jiahao
  • 13
  • 6
1
vote
1 answer

How to RAISERROR from MSSQL into Python Pandas/SQLAlchemy

Anaconda 2 Pandas 0.17.1 SQLALchemy 1.0.11 Im executing an Store procedure that returns an RAISERROR that works fine inside SQL manager studio and print the messenger well. But when I call this procedure inside Python (PyCharm 5) forcing to return…
Flib
  • 165
  • 3
  • 14
1
vote
2 answers

Extremely slow SELECT statement with WHERE on a FK field

I have this query below, and it's extremely slow. It takes almost 2 minutes for run to return 3,008 records out of a table with 99 million records. The first query where it gets "Article" data is super fast, less than 1 second and always returns 1…
Andy
  • 1,243
  • 3
  • 22
  • 40
1
vote
0 answers

SQL Query perform slow with increasing users

I have an asp.net web application with SQL server 2014 express database. My application runs well until data entry records are less, but as the data entry records saving increases, not every time but sometime page takes too long to load back again.…
user2168778
  • 39
  • 4
1 2 3
…
22 23