Questions tagged [sql-server-2017-express]
51 questions
0
votes
2 answers
(mssql) How can i add extra columns in extracted data
i have this code below (running on sql server 2017):
WITH selection AS (
SELECT servertimestamp
FROM eventlog
WHERE servertimestamp BETWEEN '5/29/2018' AND DATEADD(dd, +1, '6/29/2019')
AND (attributes LIKE…
we_mor
- 478
- 5
- 20
0
votes
1 answer
MS SQL 2017 Express: Weird error on restoring backup
I'm getting the following error on restoring backup using MS SQL 2017 Express:
Msg 3287, Level 16, State 1, Line 11
The file ID 2 on device 'C:\Backups\Test180529.bak' is incorrectly formed and can not be read.
Msg 3013, Level 16, State 1, Line…
ShamilS
- 1,410
- 2
- 20
- 40
0
votes
1 answer
SQL Server Databases missing after installing SQL Server Express
I installed SQL Server 2017 Express as a named Instance alongside my default instance. After rebooting once - both were showing but the I could not connect to SQL Server Express remotely. I then followed the instructions to enable IP on SQL Express…
Reddspark
- 6,934
- 9
- 47
- 64
-1
votes
2 answers
TSQL: Add lines to "SELECT" result set
we're using SQL Server 2017 Express and I have this SELECT statement:
SELECT * FROM
(SELECT '' as ItemId, '-- Please select --' as ItemDesc
UNION
SELECT [id] as ItemId, [DisplayName] as ItemDesc
FROM [table]
) as t
ORDER BY
CASE…
Lammi
- 77
- 7
-1
votes
1 answer
SQL Server Express trusted_connection fails when using adodb.connection
I installed SQL Server 2017 Express on Windows 10. I couldn't get it to connect using adodb. I am able to connect to it from SQL Server Management Studio, I can query the tables, etc, it works fine, but not from asp.
This is from my asp classic…
coder
- 4,121
- 14
- 53
- 88
-2
votes
1 answer
Unable to install SQL Server 2017 Express Database Engine Services
I've been trying to install SQL Server Express 2017 for the past two days, but the installation completes with an error where the Database Engine Services and the SQL Server Replication fails to be installed. I also get this error pop-up…
Pavi Kunusilin
- 1
- 2
- 5