SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,748 questions
3 answers
SQL Server Installation Problem
Hello, I was trying to install the basic version of SQL Server 2019 but accidentally downloaded it to the wrong disk. I wanted to uninstall and reinstall it but I faced an error. I followed the instructions from the posts below (linked): …
asked 2021-03-07T17:00:54.637+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 89%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nuray Nasib
1
Reputation point
commented 2021-03-15T01:17:42.977+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,606
Reputation points
1 answer
Access violation apos processar Insert into sql server
Ambiente - Win 10 Pro , Sql server 2019 INSERT INTO VENDAS (CODIGO) VALUES ('xzc'); Access violation at 0x000002BE89A80093 read to 0x0000000000000001 in 'C:\Users...\x97.exe' crash --> 000002BE89A80093 66837C770200 cmp word [rdi+rsi*2+0x2], 0x0…
asked 2021-03-09T14:50:35.537+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 54%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
francisco souza filho
1
Reputation point
commented 2021-03-15T01:16:07.543+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
SQL Server query loggin
When i execute a drop view query i don't see it in the query logging. Goal is to store all the executed queries. How can i achieve this? use [MY_DB] go create view test as select '1' as one ; go DROP VIEW [dbo].[test] ; SELECT sql_text.text,…
asked 2021-03-11T10:42:55.15+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 18%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Maarten van de Poel
21
Reputation points
accepted 2021-03-14T13:25:40.037+00:00
Maarten van de Poel
21
Reputation points
1 answer
Bad performance in SQL Server 2019 to SQL Server 2016 Snapshot replication
Hi. I'm trying to replicate a database from SQL Server 2019 to another database on SQL Server 2016. Both servers are connected through internet. I have a perfomance trouble with a table with 80 millions of records. SQL Server does a bulk copy of…
asked 2021-03-11T21:35:11.003+00:00
Juan Antonio Riquelme Cutillas
1
Reputation point
commented 2021-03-14T10:12:28.193+00:00
Erland Sommarskog
101.2K
Reputation points MVP
4 answers
One of the answers was accepted by the question author.
How get back up of database and store it in another server automatically
Hi, I have two servers, I want to schedule to take the backup of the database and store it in another server automatically. SQL version: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation…
asked 2021-02-28T09:55:50.337+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 80%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
nawid ahmad noori
21
Reputation points
accepted 2021-03-14T09:53:05.747+00:00
nawid ahmad noori
21
Reputation points
5 answers
One of the answers was accepted by the question author.
After upgrade to VS Studio 2019 v16.8.6 unable to Add New Report ... "Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))
Hi All, R Recently I upgraded Visual Studio 2019 v16.8.6. Since then, I have been getting the error: I am able to work around this problem by either copying an existing report, or using the Wizard, but this is annoying. I have…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 1%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Case When ISNULL
Hi, I have the following Case statement, but my logic doesn't seem to work, any idea why this is please? case when method = 'TP' and second_method ISNULL then 'New' end as Method_Type This is my error message: An expression of non-boolean type…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
New SQL Server - license grace period
We are currently using SQL Server 2014 and want to stand up a new SQL Server 2019 instance on a new server (newer OS) to upgrade all our databases into. During the cutover time, both the 2014 and 2019 instances will coexist. Is there a grace period…
asked 2021-03-10T19:54:44.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 53%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Darryl Schmidt
21
Reputation points
accepted 2021-03-12T14:33:23.75+00:00
Darryl Schmidt
21
Reputation points
2 answers
Deseo eliminar un archivo desde de descargar de un sftp
Estimado tengo el siguiente codigo que me permite conectarme a un sftp a traves de un ssis pero no se como eliminar el archivo despues de descargar tendran o conceran alguna forma. // Cree un nuevo objeto de proceso para ejecutar WinSCP Process winscp =…
asked 2021-03-04T21:00:30.057+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 57.99999999999999%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Prieto Velis, Erik Abelardo
1
Reputation point
commented 2021-03-12T09:55:34.533+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
1 answer
SCOM How to Get Ressource Pool from object networkdevice in Powershell
Hello there We are doing a side to side upgrade for our SCOM env. from 2012 to 2019. To compare the network devices, we're currently writing a powershell script, which compares the devices from env. A to the new env. B. and lists the missing devices…
asked 2021-03-03T13:40:13.993+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 10%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Miguet Yeung
6
Reputation points
commented 2021-03-12T09:13:13.803+00:00
Karlie Weng
14,331
Reputation points Microsoft Vendor
1 answer
need assistance on some ssis logic
Hi All I have an ssis package which processes retail sales file. I have absolutely no issue with the package as it is running fine. The issue i have is every monday I receive a csv file from the client which has Friday, sat, and Sunday dates. So…
asked 2021-03-04T16:37:42.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 69%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFJ%3C/text%3E%3C/svg%3E)
Farhan Jamil
416
Reputation points
commented 2021-03-12T09:10:11.28+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
Non-invocable member 'ScriptObjectModel.Variables' cannot be used like a method in SSIS script task
Hi Team, Have small set of code as show in bellow. // TODO: Add your code here MessageBox.Show(Dts.Variables["USER::BookingRefResult"].Value.ToString()); When am trying to debug this script task am getting bellow error …
asked 2021-03-04T11:22:32.22+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 0%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Bala Narasimha Challa
466
Reputation points
commented 2021-03-12T09:08:12.667+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
Query Timeout Expired via SQL Agent
Hello, I am trying load data from a table and upsert into the destination table. A very simple task, but there are around 30 such DF's in the graph. this is a Azure VM with 2017 sql server. Oddly, when i execute the package from within SSIS, i get no…
asked 2021-03-05T05:16:58.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 42%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
sam nick
286
Reputation points
commented 2021-03-12T09:02:49.663+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
SSIS Package writing to Excel file in Sharepoint
Hi I have an SSIS package which will write data from a DB source onto an Excel file on the sharepoint share (\sharepoint\folder\file.xlsx). This works fine through Visual Studio but fails when it is deployed to the SSIS Server and called from…
asked 2021-03-05T11:31:34.513+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sam Garth
26
Reputation points Microsoft Employee
commented 2021-03-12T08:57:03.583+00:00
Monalv-MSFT
5,896
Reputation points
5 answers
Redundant index key columns based on missing index suggestion
I have generated missing index for all my servers and below is the suggestion from SQL server DMV and I have put that in a table . Below is just two columns out of few columns. As you can see below in index_columns which I have highlighted in yellow…
asked 2021-03-11T15:51:41.357+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 42%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mario2286
441
Reputation points
answered 2021-03-12T08:53:38.803+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
tibor_karaszi@hotmail.com
4,301
Reputation points
2 answers
Microsoft SQL Server Management Studio SETUP BLOCKED
![75493-screenshot-855.png][1] [1]: /api/attachments/75493-screenshot-855.png?platform=QnA Actually my ssms work fine before i merge my local disk E with Local Disk C plz help
asked 2021-03-08T14:06:27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 90%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Venzt21
1
Reputation point
commented 2021-03-12T08:47:58.503+00:00
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
1 answer
the decryption operation failed
Hi, I reinstalled my computer few days ago and wanted to install microsoft sql server 2019 today, but when i was downloading files via the installer i got error saying ,,Failed to execute activity MediaDownloadActivity. The decryption operation…
asked 2021-03-09T15:19:25.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 24%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
tejmes
1
Reputation point
commented 2021-03-12T08:41:07.407+00:00
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
2 answers
SQL Server Mirror license
Does a mirrored server needs a sql server license? We are going to upgrade to SQL 2016
asked 2021-03-09T17:17:53.207+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 96%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Song, Lucy
1
Reputation point
commented 2021-03-12T08:35:00.627+00:00
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
1 answer
What is the difference between a key attribute and non-key attribute within an Dimension?
Hello There, I have been trying understand attribute properties, and couldn't understand what are key attributes and non-key attributes and the relationship between as described in the MS SSAS documentation. Please find the word document attached to this…
asked 2021-03-03T23:12:49.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 74%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ArunRaaman
991
Reputation points
commented 2021-03-12T08:28:25.513+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,816
Reputation points
1 answer
group customers in a column
Hi Community, I am stuck with the problem, in one column there're different customers, in another one - different values. I need to group customers and sum up values for the groupped customers, show this in a Matrix in Power Bi, but actually nothing's…
asked 2021-03-08T13:27:36.257+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 77%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lana
1
Reputation point
commented 2021-03-12T08:23:32.443+00:00
Lukas Yu -MSFT
5,816
Reputation points