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
4
votes
2 answers

Is it more efficient to execute one update with multiple columns vs multiple updates

What do you think is better. Update every time all columns of an table even if there are not all values changes, or update only the changed columns with multiple updates. The idea is, rather than to update every single change immediately, waiting…
mitch
  • 115
  • 3
  • 8
4
votes
2 answers

Connection string for SQL Server 2014 Express (VBA)

I am trying figure out what needs to go in the connection string for SQL server via VBA. This is the code I have right now, Sub ConnectSqlServer() Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim sConnString As String '…
user1452705
4
votes
2 answers

Returning a varchar value from a coalesced int calculation

I'm a newbie learning my way around T-SQL using the AdventureWorks2012 database. I'm using SQL Server 2014, though a solution that would also work with 2008 would be great. I've been given the below exercise: Write a query using the…
Julian Drago
  • 719
  • 9
  • 23
4
votes
1 answer

SQL Server 2014 Express not working

I am new to database. Tried to add new item in Visual Studio 2010 in Windows 8 i.e. "SQL Server Database" and getting the following error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The…
Manoj Pathak
  • 209
  • 1
  • 5
  • 15
4
votes
2 answers

Cannot launch SSMS (SQL Server 2014 Express) - Invalid license data. Reinstall is required

I've got a new server running Windows Server 2012 RS and IIS 8.5. I've installed SQL Server 2014 Express and was having problems getting sites under IIS to connect to (initially placeholder) databases. In an effort do get the Visual Studio 2010…
Chris Walsh
  • 3,423
  • 2
  • 42
  • 62
4
votes
1 answer

Uninstalling SQL Server Management Studio 2014 in Windows 8

I have a student who installed SQL Server 2014 with tools, but the Management Studio part did not install. There is no SSMMS.EXE on the machine. So I tried to reinstall it, and the Management Studio tools come up checked but grayed out, so the…
Eric Walden
  • 41
  • 1
  • 1
  • 2
3
votes
4 answers

Select which value is greater based on two different columns

I would like to select which rate is greater and enter it in a single query result based on the results of a UNION ALL. For example employee 200 makes 25 dollars as a base rate per hour but the job he works on has a base rate of 10.00. He should be…
BrianMichaels
  • 522
  • 1
  • 7
  • 16
3
votes
1 answer

Msg 102, Level 15, State 1, Line 6 Incorrect syntax near 'Reference'

I'm sure I'm missing something here, and could use a hand. The error message I'm getting is in the title. I've got a column called Agent Reference with results as 80008_23456 etc etc, the first part is the same (80008) for every row with only the…
Matt
  • 33
  • 1
  • 3
3
votes
2 answers

Why is my SqlConnection entering a broken state during execution?

I have a simple console app that is executing a series of stored procedures about 150,000 times. It's purpose is to import initial database data into a new instance of the database. It runs fine at work, but at home I am trying to use Sql Server…
Ryan Mann
  • 5,178
  • 32
  • 42
3
votes
1 answer

SQL Server 2014 Express Setup is not creating Configuration.ini file

I'm trying to create a "Configuration.ini" file to automate a future SQL Server Express 2014 installation. I have found several posts from all over the 'Net that tell me to go thru the installation as normal, choose all my settings, and before it's…
Ryan
  • 1,300
  • 12
  • 29
3
votes
1 answer

SQL Server 2014 Express Replication

I'm new to Sql Server and would like to know whether can setup SQL Server 2014 Express as a Publisher Server for Replication? I cannot find the Local Publication node in Replication folder tree.
user1220497
  • 311
  • 2
  • 4
  • 15
3
votes
1 answer

Linked Server SQL Server 2014 to SQL Server Version 8

I have recently installed SQL Server 2014 Express and need to create a linked server. I have tried this in SQL Server Management Studio (from the object explorer - server objects - linked servers - add linked server). When connecting to the server…
Emma
  • 577
  • 1
  • 13
  • 27
3
votes
1 answer

Full text search syntax error

I created a full text search with a catalog and index and the contains query works fine when I run a query with one word like below. SELECT Name FROM dbo.Gifts WHERE CONTAINS(Name, 'gift') it returns 'test gift' I have only one row in the table and…
chuckd
  • 13,460
  • 29
  • 152
  • 331
3
votes
3 answers

SQL Server 2014 Express Set Up

I have downloaded Microsoft SQL Server Management Studio 2014 Express. I have set it up and I now need to connect to the server. I think my server name has something to do with my computer name but its not working. How do I get in?
Chris
  • 435
  • 7
  • 19
2
votes
1 answer

Format of the initialization string does not conform to specification starting at index 124

Trying to access a SQL Server 2014 database with Visual Studio 2017; on each run, it shows this error System.ArgumentException: Format of the initialization string does not conform to specification starting at index 124 Read some questions already…
Kaleem
  • 129
  • 1
  • 14
1
2
3
…
22 23