SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,850 questions
7 answers
Extract Data-tier application ?
Hello, a user has requested for me to run within SQL Server Management Studio -> Tasks -> Extract Data-tier Application I'm not familiar with this and type of request if it's safe for me as DBA to run and provide to user. I read Microsoft's Doc…
asked 2021-03-16T20:10:30.893+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(102.4, 45%, 19%)' 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)
techresearch7777777
1,796
Reputation points
commented 2021-03-19T01:33:59.863+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
4 answers
SSAS calculated member - time hierarchy - filter member
Hello, I have a time hierarchy [TIME].[Year-Month] with levels [ALL] and [Year] and [Month]. Now I want set the value of measure to null for a specific month, which works on [Month] level with the following block: CREATE MEMBER…
![](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, 63%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWP%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
SQL Server 2008R2 Security Update 10.50.6560.0
Does SQL Server 2008R2 Security Update 10.50.6560.0 (Meltdown/Spectre) include the TLS1.2 update 10.50.6542.0? I can see the TLS1.2 update is a lower build number, but I can't find anywhere that states that the higher update includes the lower one(s) -…
![](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, 11%, 24%)' 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)
1 answer
One of the answers was accepted by the question author.
SQL Agent jobs schedules
Hi everybody, I have about 30 SQL Server Agent jobs. I want every job (except for a few not ours) to have the schedule named SCHED_ + name of the job. Some jobs already have schedule named this way, some use (and share) the schedule named differently.…
3 answers
One of the answers was accepted by the question author.
How to close datareader for ADO.NET source
Hi I have created a package for data migration. My package use both execute SQL Task and Data flow task. First data flow task(using ADO.NET source) works smoothly, when package flow reach second data flow task (using ADO.NET source), I get error …
![](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(22.400000000000002, 52%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Masking and External Tables
All, The script below works fine on SQLServer 2019: CREATE TABLE DefaultMask ( ID INT IDENTITY (1,1) PRIMARY KEY NOT NULL ,Name VARCHAR(255) NULL ,BirthDate DATE NOT NULL ,Social_Security BIGINT NOT NULL ); GO But the below script below…
![](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, 51%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
2 answers
How to script OPTIMIZE_FOR_SEQUENTIAL_KEY using smo?'
Hi. I am on SQL Server 2019 / DB Edition 150. When scripting via SSMS I get tables out with OPTIMIZE_FOR_SEQUENTIAL_KEY: CREATE TABLE ... CONSTRAINT ... PRIMARY KEY CLUSTERED ( WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =…
![](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(102.4, 75%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB1%3C/text%3E%3C/svg%3E)
3 answers
Failover Cluster Manager says Chkdsk scan needed on a volume
Good afternoon, I noticed one day that FCM says that a chkdsk scan is needed on a very large volume that is used for a very large database. I ran chkdsk (no switches) and it came out clean. DBCC CheckDB (offloaded) came out clean as well as DBCC…
asked 2021-03-16T19:52:36.843+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(160, 22%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJY%3C/text%3E%3C/svg%3E)
James Yang
1
Reputation point
commented 2021-03-18T12:18:56.907+00:00
James Yang
1
Reputation point
4 answers
Help with DAX Meassure
Hello everyone, I'm diving into DAX measures and, being my second try at DAX, I have an issue with the meassures that I don't understand, or DAX, really, for that matter. Sample file:…
![](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(64, 27%, 16%)' 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)
5 answers
One of the answers was accepted by the question author.
Rebuild index in SQL server system database
Hi, I just want to confirm , is it recommended to rebuild indexes in system database e.g. MSDB or distribution db in transactional replication. Thanks
asked 2020-10-20T12:14:14.51+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, 78%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZB%3C/text%3E%3C/svg%3E)
Zahid Butt
556
Reputation points
accepted 2021-03-18T11:46:10.363+00:00
Zahid Butt
556
Reputation points
1 answer
RDL subreport filter
is there an option to set multi values as parameter for subreport? and if so, how? i want to pass as a filter multi countries values =Join(Parameters!Country.Value,",")
asked 2021-03-07T19:12:05.723+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(176, 27%, 27%)' 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)
Lior
1
Reputation point
commented 2021-03-18T11:17:44.477+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(268.8, 74%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Lior Rozani
1
Reputation point
1 answer
Analysis Server Pivot Table shows DimensionPermission warning while starting refreshing
I´m an Analysis Server Admin. I opened the SQL Server Management Studio and connected to Analysis Server Database. Then I opened a role and add a new member. The new member opened Excel and connected himself to the Analysis Server Database. If he load…
asked 2021-03-03T10:35:17.047+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(134.4, 42%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Stefan Radtke
1
Reputation point
commented 2021-03-18T09:46:26.627+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
2 answers
Custom functions not working in group levels in
![75937-a01-report-services-error-01.jpg][1] [1]: /api/attachments/75937-a01-report-services-error-01.jpg?platform=QnA One last problem. Where I have drills on reports the group levels are not formatting according to the custom functions being used to…
asked 2021-03-09T17:46:40.067+00:00
Peter Nolan
1
Reputation point
commented 2021-03-18T09:35:21.697+00:00
Lukas Yu -MSFT
5,816
Reputation points
4 answers
Simplest way to import XML file content into XML column in SQL Server using SSIS
What is the best way to import data from XML file into a single XML column in a database? (The whole XML from the file)? I'd like to use SSIS and I already tried BULK LOAD from OPENROWSET and got an error about file not existing, Need a different…
asked 2021-03-07T23:29:31.81+00:00
Naomi
7,361
Reputation points
commented 2021-03-18T09:30:56.873+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
2 answers
Recommended provider for Snowflake DW Connectivity
Hi - Am looking for Microsoft recommended providers for establishing datasource connection with Snowflake Data warehouse via SQL Server Analysis Services Tabular 2016 (On-prem). Came across articles suggesting CData providers enabling this set up…
asked 2021-02-22T16:58:28.997+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, 97%, 12%)' 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)
Manoj Muthusamy
1
Reputation point
commented 2021-03-18T09:27:48.543+00:00
Lukas Yu -MSFT
5,816
Reputation points
1 answer
SSRS: bulk rename reports
Hi. We have many legacy reports that have not been executed in a long time. I can find these from a persisted version of the ExecutionLogStorage table (or the fact that they are not in there at all but are in the catalog table). I have tested…
asked 2021-03-09T15:54:55.937+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(121.6, 7.000000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Michael Edwards
1
Reputation point
commented 2021-03-18T09:10:06.477+00:00
Lukas Yu -MSFT
5,816
Reputation points
5 answers
One of the answers was accepted by the question author.
How to delete from trades table when Part id not exist on mapping table and have count =1 and on code type 3030?
How to delete from table trades where Part id not exist on mapping table and have count =1 and on code type 3030? I work on sql server 2012 I face issue i can't delete partid from table trades table where Partid not exist on mapping table and…
asked 2021-03-14T18:10:46.82+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 2021-03-18T08:24:21.93+00:00
ahmed salah
3,216
Reputation points
4 answers
One of the answers was accepted by the question author.
SSIS Excel Source Assisstance
So I recently started with SSIS and I am having problems when deploying a data flow. I got it to work in visual studio by changing Run64BitRuntime on the package to false: However when the package is deployed it does not work, I created a SQL…
asked 2021-03-17T12:24:16.787+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(89.60000000000001, 92%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Taariq Toffar
21
Reputation points
accepted 2021-03-18T07:56:49.383+00:00
Taariq Toffar
21
Reputation points
1 answer
SSRS2019 WITH ORACLE STORED PROCEDURE FAILS WITH WRONG NUMBER OF TYPES OF ARGUMENTS
CREATE PROCEDURE TESTLV_PROC (L_CURSOR OUT SYS_REFCURSOR) IS BEGIN OPEN L_CURSOR FOR SELECT * FROM DW_ORGANIZATION; END; /
asked 2021-03-16T21:58:32.4+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(278.4, 81%, 36%)' 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)
LS2021
6
Reputation points
commented 2021-03-18T07:25:01.053+00:00
ZoeHui-MSFT
33,386
Reputation points
1 answer
Sql Server Reporting Server connect report server db with encrypted connection
I use sql server reporting server to host my msreporting.I want to encrypt my sql server connection (not connection string I mean ,its is already encrypted) encrypted on network traffic traffic Normally I can add encrypt=true value to mysqlserver…
asked 2021-03-14T11:11:07.657+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, 16%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBY%3C/text%3E%3C/svg%3E)
Bilgehan Yıldız
1
Reputation point
commented 2021-03-18T06:40:41.423+00:00
ZoeHui-MSFT
33,386
Reputation points