SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 questions
1 answer
Not able to Restore MS SQL Server database from Barracuda Appliance....
Here is the agent logs from backend. 11/26/2020 11:56:52 0x000016b4 Critical: Exception - Description: The writer experienced a non-transient error. If the backup process is retried, 11/26/2020 11:56:52 the error is likely to reoccur. Original:…
asked 2020-11-26T09:36:47.647+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(99.2, 7.000000000000001%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
saddyAL
21
Reputation points
commented 2020-11-27T03:28:11.35+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,626
Reputation points
1 answer
sqlserver Azure linux limitations
hello Im new to sqlserver , Im working on sqlserver Azure Linux, it seems it has some limitations has anyone have a list of full limitations on Linux Azure I found the link below, however is kind of generic …
asked 2020-11-25T15:37:41.52+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(192, 71%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
helena Matos
61
Reputation points
commented 2020-11-27T01:27:55.873+00:00
CathyJi-MSFT
21,871
Reputation points Microsoft Vendor
5 answers
Query timeout Linkedserver is not working
hi, i have an issue, i've configued 3 linked server each one is use to execute a store procedure on another sql server instance, i've configured the query timeout in 10 seconds but sometimes the query stops after 15 seconds. Once the quey was run for…
asked 2020-11-23T15:58:25.007+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(192, 54%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Camilo Ponce Catalan
1
Reputation point
commented 2020-11-26T22:48:39.707+00:00
Erland Sommarskog
110.4K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
SQL Server Create Database Defaults
A number of the default options are not desired SET ANSI_NULLS OFF SET ANSI_PADDING OFF SET ANSI_WARNINGS OFF SET ARITHABORT OFF But is it best to leave these , and individual connections override?
asked 2020-11-26T12:11:32.413+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(112.00000000000001, 30%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Adam Newcombe
156
Reputation points
commented 2020-11-26T22:37:05.24+00:00
Erland Sommarskog
110.4K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
How to grant Schema Owner to a user ?
Hi, There is a request for becoming Schema Owner for "dbo" for a particular database. Currently, he already gets the following database role db_datareader db_datawriter db_dlladmin He mentions that without being the Schema…
![](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, 99%, 24%)' 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)
2 answers
One of the answers was accepted by the question author.
compression FILESTREAM SQL Server Express 2014
Supprimer l'alerte|Modifier|Type de modification Question Vous ne pouvez pas voter pour votre propre billet. 0 Hello I'm Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server Express 2014, the problem is when I store the image…
![](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(124.80000000000001, 56.00000000000001%, 22%)' 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.
What to buy for 40 v-core enviroment?
My Client have to but SQL 2019 license. Virtual machine is built from 4 X CPU's with 10 physical cores each, so 40 physical cores together. EULA, as I understand suggest to count it as v-cores equal with threads in CPU's. For me it is 80 v-cores, co 40 x…
asked 2020-11-26T14:18:30.607+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(256, 95%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Daniel Kubiczek
41
Reputation points
answered 2020-11-26T18:54:26.193+00:00
Daniel Kubiczek
41
Reputation points
1 answer
One of the answers was accepted by the question author.
How to update status with message wrong sequnce for all numbers where there are numbers remaining or down on sequence ?
I work on SQL server2012 I face issue I can't stop insert data on group table when Numbers not complete sequence or have numbers not exist or down . as example seqManual are 1,2,3,4 per only groupseq B so that Insert data success to table groups . but if…
asked 2020-11-26T02:15:05.857+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(262.40000000000003, 77%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ahmed salah
3,216
Reputation points
commented 2020-11-26T14:43:45.533+00:00
Viorel
116.7K
Reputation points
8 answers
One of the answers was accepted by the question author.
In win10 20H2 version, when installing sql Server 2014 express SP1, Exit code (Decimal): -2068119551 occurs. What should I do?
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068119551 Exit facility code: 1211 Exit error code: 1 Exit message: Attempted to perform an unauthorized operation. Start time: 2020-10-26 13:29:33 End time:…
asked 2020-10-26T12:09:34.113+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(51.2, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
fangfangdlyuxue
41
Reputation points
answered 2020-11-26T13:30:43.077+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(262.40000000000003, 49%, 35%)' 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)
高稔 山田
1
Reputation point
1 answer
load files into sql server
Hello, I come from the ssis background where I am able to load .csv files one at a time into sql server... Can you please point me to video or a step by step lab/documentation where it sows me how to load .csv files one at a time in a loop into say…
asked 2020-11-24T08:32:10.813+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(262.40000000000003, 97%, 35%)' 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)
arkiboys
9,691
Reputation points
commented 2020-11-26T09:41:55.563+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
load files into sql server
Hello, I come from the ssis background where I am able to load .csv files one at a time into sql server... Can you please point me to video or a step by step lab/documentation where it sows me how to load .csv files one at a time in a loop into say…
asked 2020-11-24T08:32:10.813+00:00
arkiboys
9,691
Reputation points
commented 2020-11-26T09:41:55.563+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
Attunity TeraData Source & Destination components not showing up in SSIS Data flow task
Hi All, I am trying to install SQL Server 2014: Microsoft Connector Version 3.0 for Teradata by Attunity to take advantage of ssis Data flow Teradata Source component but unfortunately component is not showing up. Please let me know if have done any…
asked 2020-11-23T21:45:52.693+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(307.2, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Gopinath Desai
46
Reputation points
commented 2020-11-26T09:39:16.127+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL Server Analysis Service Problem
Hello Sir/Madame; I have a question about SQL Analysis Server. when I try to login with effectiveuser"domain name\username" it login for every user in the domain expect one user. I tried many thing but I couldn't solve this problem, when I…
asked 2020-11-23T14:03:07.29+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(25.6, 87%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
Davut EREN
21
Reputation points
accepted 2020-11-26T09:15:07.207+00:00
Davut EREN
21
Reputation points
2 answers
SSRS 2016 iisue- Failed to deploy report 'SystemCenter.Operations.Manager.Health.Check.Report.Library.Report.Misc.OMSManaged'. AdjustDataSources: Exception
SCOM 2019, SSRS 2016- with event id 31567 is OPS Mgr log. I find plenty of references for SSRS2017 but none for fixing the issue with SSRS 2016. Data Warehouse failed to deploy reports for a management pack to SQL Reporting Services Server. Failed to…
asked 2020-11-25T16:50:27.52+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(28.799999999999997, 92%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tony Strother
171
Reputation points
answered 2020-11-26T08:59:52.577+00:00
SChalakov
10,381
Reputation points MVP
2 answers
User security Matrix - Roles
Hi Everyone, I have a tabular cube that contains Dimension "Employee" which contains informations on the employees (first name, last name, full name ...), other Dimension "Region" that contains the geographical informations…
asked 2020-11-05T16:14:47.117+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(313.6, 30%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Samir abdelmalek
21
Reputation points
commented 2020-11-26T08:46:00.96+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,821
Reputation points
8 answers
Calculated measure in linked measure group is not refresh after cube writbeck
Hi All, I have two SSAS cubes: 1.Cube C1 with measure m1, writeback enabled partition 2.Cube C2 with measure m2 I have created cube C3 with two linked measure groups: C1 (measure m1) and C2 (measure m2). In cube C3, I have created calculated…
asked 2020-11-06T11:26:19.81+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(38.4, 73%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dorota Papiernik
1
Reputation point
commented 2020-11-26T08:38:09.3+00:00
Lukas Yu -MSFT
5,821
Reputation points
1 answer
How to post a question with code
I am trying to post a question with some VB code but it keeps saying: Access Denied You don't have permission to access "http://learn.microsoft.com/answers/questions/ask.html" on this server. Reference…
asked 2020-11-24T20:18:50.823+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(112.00000000000001, 13%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
mark goldin
691
Reputation points
commented 2020-11-26T08:38:08.91+00:00
ZoeHui-MSFT
36,116
Reputation points
4 answers
Error 0xC0014009 for a SSIS 2017 package to import data from a SAP HANA 64-bit OBDC source
I'm trying to a SSIS 2017 package that connects a SAP HANA OBDC source. In the dev machine having Visual Studio and the 32-bit ODBC driver, the package functions without any problems inside VS. In the prod machine having a system DSN with the…
asked 2020-11-17T08:16:09.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(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pmscorca
987
Reputation points
answered 2020-11-26T08:19:57.057+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
One of the answers was accepted by the question author.
Relational Table Purge issues with Sliding Window Partition
Dear Experts, I have recently implemented the Sliding Date Range partition for one of the Primary / Foreigin Relational Tables. Partitioning was working fine but I am having a challenge while the Purge partition. Here is the Table Structure I have …
asked 2020-11-24T06:32:57.193+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(256, 91%, 34%)' 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)
Azmath Momin
61
Reputation points
commented 2020-11-26T06:50:31.17+00:00
Azmath Momin
61
Reputation points
0 answers
Access to a database consult editor
The last week I could enter without problems to the database consult editor, now I can´t. It asks me for my account, but when i put it, It still doesn't let me enter like the last week, and I didn't do anything with azure during the week... How can I…
asked 2020-11-25T03:38:11.003+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(233.6, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Andre Castro
1
Reputation point
commented 2020-11-26T06:35:38.137+00:00
Cris Zhan-MSFT
6,626
Reputation points