Top "Sql-server-2017" questions

Use this tag for questions specific to the 2017 version of Microsoft's SQL Server.

How do I find running Traces in SQL Server?

Is there an easy way to determine what traces have been set up by sp_trace_create on SQL Server 2000? …

sql-server sql-server-2008 sql-server-2005 sql-server-2012 sql-server-2017
Error when installing SSDT (SQL Server Data Tools)

I have a problem during the installation of SQL Server Data Tools for Visual Studio 2017 I get the following error (…

sql visual-studio-2017 ssms sql-server-data-tools sql-server-2017
SQL Server 2014 installation stuck (hung up) or taking very long time to finish

I'm trying to install SQL Server 2014 but it stays in the same spot (Install_VCRuntime_Cpu32_Action) for hours. It's …

sql-server installation sql-server-2014 sql-server-2017
Get unique values using STRING_AGG in SQL Server

The following query returns the results shown below: SELECT ProjectID, newID.value FROM [dbo].[Data] WITH(NOLOCK) CROSS APPLY STRING_…

sql sql-server sql-server-2017 string-aggregation
SQL Convert Milliseconds to Days, Hours, Minutes

I need convert a millisecond value, 85605304.3587 to a value like 0d 18h 21m. No idea on how to start that, …

sql sql-server tsql sql-server-2017
Produce DISTINCT values in STRING_AGG

I'm using the STRING_AGG function in SQL Server 2017. I'd like to create the same effect as COUNT(DISTINCT <…

sql sql-server distinct sql-server-2017 string-aggregation
SQL Server 2017 Installation issue on window 7

I am facing problem installing SQL Server 2017 (Developer as well as Express editions). I get an error: Your operating system …

sql-server-2017
How to fix System.Data.SqlClient.SqlException: Login failed for user

When I run it I get this: Error Screenshot I enabled Windows authentication in IIS, SQL Server, and also added …

c# connection-string sql-server-2017
"Oops" error while installing SQL Server 2017 developer edition on Windows 10

I'm trying to install SQL Server 2017 Developer edition with "Basic" installation type but it gives below error message: Oops... Unable …

sql-server installation sql-server-2017
CLR Strict Security on SQL Server 2017

MSDN on this article says: CLR uses Code Access Security (CAS) in the .NET Framework, which is no longer supported …

.net sql-server sqlclr sql-server-2017 code-access-security