Drivers used to connect to SQL Server - social.msdn.microsoft.com
Jan 25, 2019 · However you may need SQL native client to use SqlConnection. Use the link I provided to download the native client for SQL 2012, or just install the "Client Tools" on your …
How to get date and year range in SQL? - social.msdn.microsoft.com
Oct 7, 2021 · Depending on your db you have functions such as GETDATE () or GETUTCDATE () to get the current date (SQL Server). The YEAR () function allows to extract the year. Check …
Error Oracle Data access DLL - social.msdn.microsoft.com
Mar 14, 2019 · i'm developping a c# script in SSIS to insert data in an oracle DB (VS 2017 Pro).
SQL Server 2019 Downgrade rights - social.msdn.microsoft.com
Nov 29, 2019 · Hello, can someone tell me if it's possible to downgrade the license from SQL server 2019 standard to 2016 standard? Thanks Friday, November 15, 2019 3:36 PM
Error installing SSIS project template in Visual studio 2019
Mar 2, 2020 · Download link: SQL Server Integration Services Projects Friday, February 28, 2020 12:52 PM 0 Sign in to vote Hi Yitzhak
Cannot Open the Server from SSMS - social.msdn.microsoft.com
May 7, 2020 · Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection …
Limiting the number of concurrent sessions per user
Feb 12, 2019 · As following to my local security policy, I have to establish the limit appropriate to the type of user account accessing the SQL Server instance on SQL Server 2014 Enterprise.
Running total with WHILE loop - social.msdn.microsoft.com
Sep 30, 2019 · I am looking for a running total solution using not the window functions but a while loop. In this case, I have #t table with 2 fields and some data in @list . So, I need to load data …
uploading xslt files in 2017 - social.msdn.microsoft.com
Aug 29, 2019 · I am transitioning from SSRS 2012 to 2017. I have a number of reports that use Data Transformations. On my 2012 server I simply created a hidden folder and dumped all my …
Who stopped my SQL Services - social.msdn.microsoft.com
Dec 7, 2019 · Yes. it is a user who is local admin. But in case , if we want to track down who stopped sql services, then as a sqladmin can we do any kind of logging before shutting the …