sql-server-2017 Questions
3
Solved
I get an error querying a remote postgresql server from my sql server 2017 Standard via a linked server
this is the query:
SELECT CAST(test AS VARCHAR(MAX)) FROM OpenQuery(xxxx,
'SELECT corpo:...
Bebebebeerine asked 20/6, 2019 at 10:1
3
Solved
We have a legacy application that fails to connect to SQL Server on certain computer (we have activated TLS, and that computer now raises an SSL error).
The problem is that the application is...
Bleareyed asked 27/6, 2022 at 13:21
2
Solved
EF Core 8 now inlines values in where statements using a combination of WHERE IN and OPENJSON as opposed to the previous WHERE IN(...).
This change is noted in the documentation and the stated reas...
Sangria asked 22/12, 2023 at 13:42
4
I have a SSIS job which run well in SQL Server 2008 but no longer working in SQL Server 2017. The error message I get is:
Cannot create a task from XML for Task "Email", type "Microsoft.Script.T...
Tridentum asked 29/6, 2019 at 7:6
3
Details:
SQL Server 2017 (Developer or Express edition)
Windows 2011 OS
I have followed this article already but no avail https://blog.sqlauthority.com/2017/01/27/sql-server-sql-installation-fail...
Leastwise asked 6/2, 2022 at 0:28
11
Solved
The following query returns the results shown below:
SELECT
ProjectID, newID.value
FROM
[dbo].[Data] WITH(NOLOCK)
CROSS APPLY
STRING_SPLIT([bID],';') AS newID
WHERE
newID.value IN ('O958...
Inshore asked 29/5, 2018 at 16:33
6
Solved
I'm using the STRING_AGG function in SQL Server 2017. I'd like to create the same effect as COUNT(DISTINCT <column>). I tried STRING_AGG(DISTINCT <column>,',') but that is not legal syn...
Orthography asked 2/8, 2018 at 5:52
2
Why does a merge into a temporal table with a nonclustered index in the history table throw an error
I get the following error when I try to merge under a few conditions. Is someone able to explain why? Seems like it's a problem with SQL Server itself, but I wanted to post it here to confirm.
Att...
Blurb asked 16/1, 2022 at 20:48
2
Solved
I've been trying to develop a simple AspNetCore application with EntityFrameworkCore to connect and work with the MSSQL server database. And manage all this by Rider IDE, a tool for Database client...
Contempt asked 9/12, 2019 at 12:53
0
I'm trying to connect my django app to a SQL Server instance.
In development I'm using a sqlsrv created with a docker image and everything work just fine.
In production I have a connection issue:
...
Rosmunda asked 17/10, 2023 at 13:43
3
Trying to install Reporting Extension for CRM 2016 but SSRS instance is blank.
VM containing (SQL & CRM on the same machine)
Windows Server 2016
SQL Server 2017 - Microsoft SQL Server 2017 (...
Speechless asked 10/5, 2018 at 4:55
1
Solved
I get this error when I update through EF 7: "The target table 'Table' of the DML statement cannot have any enabled triggers if
the statement contains an OUTPUT clause without INTO clause.&quo...
Ardolino asked 20/12, 2022 at 11:54
1
I'm using a Local MS SQL Database, the database was created automatically using entity framework.
The database is created with out any errors.
However when I use Microsoft Managment studio ...
Obstinacy asked 12/2, 2020 at 13:38
2
I was not able to find Execute Package Utility (dtexecui) after installing SQL Server 2017. Was not able to find any standalone installer from Microsoft to install it as well. Will any one please g...
Jink asked 3/10, 2019 at 4:6
2
Solved
I'm trying to install SQL Server 2017 Developer edition with "Basic" installation type but it gives below error message:
Oops...
Unable to install SQL Server (setup.exe).
Build version...
Borlow asked 17/11, 2017 at 8:42
2
Solved
In SSMS when I do a
Find and Replace in Files
(default keystroke CTRL+SHIFT+H)
Edit > Find and Replace > Replace in Files
If I set the "Look In" to "Current Document" then do a change an...
Heron asked 24/5, 2017 at 16:43
4
Solved
I recently installed SQL Server 2017 Express and localdb (general availablity). While attempting to install the tSQLt framework I've discovered a new security feature implemented in SQL Server 2017...
Roadability asked 3/10, 2017 at 18:29
3
Solved
I have a new Windows 10 Home machine and I want to install SQL server. I already have Visual Studio 2017 installed and SSMS 2017 (Which I initially though installed SQL).
On first try I got this ...
Tricorn asked 26/11, 2017 at 11:40
3
Solved
I've setup SSRS 2017.I need to export an SSRS report using their new REST API, I've been looking through the API specification here but I can't find a method in swagger specification to render/expo...
Stultify asked 12/12, 2017 at 19:0
1
Solved
According to this link, SQL Server machine learning service's highest R version is 3.3. Does anyone know when one can upgrade to version 3.5 or later?
Or is my only option to switch to sql server...
Ci asked 16/12, 2019 at 20:55
0
If a client connects to SQL Server, and a certificate is used to power TLS encryption, how can i get information about that certificate?
Ideally i want all the details, but i'd be happy with
Issue...
Benedetta asked 16/10, 2019 at 15:13
3
Solved
Traditional left-join returns all records from the left table, including matching records:
I want to use the join to exclude matching records, and return only non-matching records from the left ...
Hill asked 14/10, 2019 at 15:54
1
Solved
I am reading microsoft docs ms sql JSON options
And I would like to check if my column Settings which is nvarchar, I put there some JSON, and if that JSON contains property name.
Is it doable?
some...
Cedillo asked 13/9, 2019 at 7:11
1
Solved
I recently encountered the problem that COUNT(*) requires the user to have select permission on every single column of a table.
Even though the spec of 'COUNT(*)' explicitly says that
it does n...
Amour asked 29/8, 2019 at 8:20
2
Assume I'm working with the graph database from this sample (SQL Server 2017):
https://learn.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-sample
I have the following SQL query:
...
Nan asked 13/10, 2017 at 15:53
1 Next >
© 2022 - 2024 — McMap. All rights reserved.