Stack Overflow
Stack Overflow

Questions tagged [sql-server-2017-express]

51 questions
121
votes
6 answers

SQL Server® 2016, 2017 and 2019 Express full download

All previous version of SQL Server Express were available in both web and full downloads. But I cannot find full download of SQL Server® 2016 Express. Does it exist? Asked the same question on MSDN forums, not much luck:…
Alex I
  • 2,078
  • 3
  • 18
  • 24
20
votes
3 answers

Error while installing SQL Server 2017 Express showing sqlncli.msi is missing in some path

I am trying to install SQL Server 2017 Express, but it is throwing this error: sqlncli.msi is not found in the path Screenshot illustrating the sqlncli.msi error:
Surya
  • 265
  • 1
  • 3
  • 10
5
votes
2 answers

In SSMS Running SQL which doesn't return rows with go between statements gives an error

I am using SSMS v17.6 with a SQL Server Express v14.0.1000.169. When I run the following DELETE statement: delete from foo go I get the error: Incorrect syntax near 'go'. But if I execute a similar SELECT statement: select * from foo go Then…
Shane
  • 2,271
  • 3
  • 27
  • 55
2
votes
0 answers

C# & SQL Server : turn sql data into class module using DataContext

I may be going about this the hard way but I am wanting to gather 1 row from the SQL Server database (by ID column), and place those values inside an instance of my class (which is chromeExtData). My class: public class chromeExtData { public…
StealthRT
  • 10,108
  • 40
  • 183
  • 342
2
votes
1 answer

SQL Server export table to .dat file

I'm using SQL Server 2017 Express, I have an eventlog table and i would like to export it to a .dat file, in order to reduce the size of my database. Is there any possible way to do this. Can anyone give me a hint about it if it's possible? Thank…
we_mor
  • 478
  • 5
  • 20
2
votes
1 answer

What are some of the best practices for tracking updates to a record over time in sql?

I have a product table with a primary key @productid (bigint), a product number (int), and a version (int) Any time someone makes changes to the product record ONLY, I plan on inserting a new row in the database with the same product number and…
Drewskis
  • 429
  • 6
  • 14
2
votes
2 answers

How to get distinct elements with all values from all arrays XML in T-SQL

I need some help trying to import the following XML document miljoner skär …
Eddie Ted Crocombe
  • 110
  • 12
1
vote
1 answer

SQL Server 2017 configuration manager missing reporting services service

This question has been been asked before, but no one has answered it. I installed SQL Server 2017 Express, created a database and installed the Reporting Services (which now is a separate download). Everything is working, BUT, when I open the SQL…
James
  • 53
  • 9
1
vote
1 answer

SQL Server is not connecting with node app

I am trying to connect my nodejs/express app to SQL Server 2017 using Sequelize ORM. This is my first time of using SQL Server. I am not sure where is the problem. Situation:- I create a database using SQL Server Management Studio I create an…
user11371378
1
vote
1 answer

SQL Server 2017 Express silent installation

With our Installer, Customer wants us to check if the SQL server is installed or not and it is not installed, the installer should install it. Also, the installation should be silent and not ask anything to the user as they are not techies. Now by…
Harsh Shankar
  • 506
  • 5
  • 16
1
vote
1 answer

Replace NULL Values in a column with Zeros on a condition

I am new to SQL Server databases and queries. I have a SQL Server database table with DateTime and Current. Current may have NULL values. I want to replace NULL values in Current column with zeros only when either previous or next record has some…
Arul 4online
  • 13
  • 3
1
vote
0 answers

SQL server Express 2017 LocalDB

As far as I know LocalDB direct download is not available for SQL Server Express 2017. Now, If I donwload "SQLServer2017-SSEI-Expr.exe" from "https://go.microsoft.com/fwlink/?linkid=853017", it shows options (Basic,Custom, Download Media) and wait…
Akis
  • 81
  • 2
  • 8
1
vote
2 answers

Creating vba code to connect to a remote SQL server, executre a stored procedure that updates a table on the accdb file

Sorry about the text, trying to be concise We are trying to set up a process to have our end users (remote users on laptops that move between different networks) who are using access databases, send a request through to our SQL server to have that…
user10389388
  • 13
  • 1
  • 3
1
vote
0 answers

Connect laravel 5.6 to SQL Server Express

I'm trying to connect a laravel 5.6 project to SQL Server on Windows I downloaded php_pdo_sqlsrv_71_ts.dll and php_sqlsrv_71_ts.dll my phpinfo looks like this But now when I try to run the migrations I get the…
gaby
  • 117
  • 1
  • 11
1
vote
2 answers

Entity Framework writes in Context but not Database

We use an UnitOfWork approach for an application based on EF 6.2.0 in C# with a SQL Server 2017 Express (14.0.1000) database backend. Our OwnContext.cs inherited from DbContext should fill the fields Id, ChangedDate and ChangedUser automatically,…
Pixel Hunter
  • 92
  • 10
1
2 3 4