SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,107 questions
2 answers
Permission to edit Agent job step - not sysadmin
We are trying to reduce the number of sysadmins on our SQL Server. But we have encountered a problem. The user gets an error. The server is SQL Server 2014 (unknown build, I don't have access). The SSMS that the user uses is also SQL Server 2014. …
asked 2020-08-18T20:37:39.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(60.8, 65%, 15%)' 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)
Loski, Russel
1
Reputation point
answered 2020-08-19T07:35:26.657+00:00
CathyJi-MSFT
21,111
Reputation points Microsoft Vendor
2 answers
New sqlserver server performance cpu issue
I am having issues with a new sqlserver 2019 server. It is a virtual server running on 2 cores and 6 logical cores with 64GB ram. It seems to not be maxing out the cpus, for example when I do a rebuild of a clustered column store index on the old…
asked 2020-08-18T16:31:15.71+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(9.6, 98%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
jonjoseph@gmail.com
1
Reputation point
answered 2020-08-19T06:32:03.163+00:00
CathyJi-MSFT
21,111
Reputation points Microsoft Vendor
1 answer
Can you increase the size of a PaaS sql after it is created? (i.e. P4 change size to P6)
Can you increase the size of a PaaS sql after it is created? (i.e. P4 change size to P6)? Can we downgrade the size from P6 to P4? Wondering if you downgrade from P6 (4 TB) to P4 (500 Gb) that if your database might be impacted? And is the…
asked 2020-08-17T14:48:04.06+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, 19%, 15%)' 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)
David Kim
66
Reputation points
commented 2020-08-19T01:08:51.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(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,611
Reputation points
5 answers
One of the answers was accepted by the question author.
SQL Server Agent - Retrying When Job Does Not Start
Using SSMS 18. I know I can use the Retry Attempts option to retry a job if it fails. What I'm wondering is whether there is a way to retry a job if it hasn't run at all. For example, I had a job scheduled to run a few nights ago but the server was being…
![](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(297.6, 35%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Can you please help to recovering a database with log file alone upto latest transactions?
I have lost the drive which hosted data file and DB is recovery so I wanted to recover the data till the last point? is that possible with log file alone ?
asked 2020-08-18T14:37:51.233+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(96, 35%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anu Grah
21
Reputation points
answered 2020-08-18T18:36:29.95+00:00
Shashank Singh
6,246
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS - Send Mail Task
Hello, I created an SSIS ETL that Loops through a local folder, inserts excel file data into a SQL db, then archives the file. I'm trying to add a Send Mail Task to the process but I can't seem to get it to work. I can get the email to run but it…
asked 2020-08-17T14:35:07.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(204.8, 66%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tim Mullady
221
Reputation points
accepted 2020-08-18T17:58:15.073+00:00
Tim Mullady
221
Reputation points
3 answers
One of the answers was accepted by the question author.
Unexpected Termination - SQL Agent - excel Import
Hi experts, According my research over google, this issue has been active since 2018. Unfortunetally I haven't found the right answer. I hope somebody could help me. I have a package in SSIS which loads an Excel file data into a Table. At the…
asked 2020-08-18T07:01:13.66+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, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Alejandro Lopez
21
Reputation points
answered 2020-08-18T14:40:38.573+00:00
Alejandro Lopez
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Display current hour Production
CREATE TABLE dbo.RAWTable(Time_Stamp datetime , Date date , Shift_Id varchar(5) , Line_Code varchar(10) , Machine_Code varchar(10) , Variant_Code varchar(20) , Machine_Status varchar(30) , OK_Parts int , NOK_Parts int , …
asked 2020-08-17T12:15:33.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(6.4, 27%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rakesh Ponnala
21
Reputation points
commented 2020-08-18T12:12:48.63+00:00
Rakesh Ponnala
21
Reputation points
1 answer
Dynamic Filtring in mdx Queries
hello... I need to deal with MDX query in SSAS tabular Server... That went almost ok with measures with summation but this is not ok if I decided to work with measures that Deal with Averages.. Since the average calculation is already defined in…
asked 2020-08-17T11:59:47.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(227.2, 8%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Radi Soufan
1
Reputation point
commented 2020-08-18T07:59:42.523+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(32, 95%, 13%)' 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)
Alexei Stoyanovsky
3,416
Reputation points
2 answers
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
I can't enable one of my product add-in due to below error message - Unable to find any Microsoft OLE DB providers on the machine. Please install "Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2008" or later. …
asked 2020-08-12T09:04:30.717+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(217.60000000000002, 69%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYX%3C/text%3E%3C/svg%3E)
Yu, Xiaoxue (Refinitiv)
1
Reputation point
commented 2020-08-18T03:24:38.253+00:00
m
4,271
Reputation points
1 answer
How to use lookup() to bring a value from another dataset into a tablix
I have two datasets that include the fields branch and sales. I using dataset1 for the rest of the table, but for one cell I want the sum of sales from dataset2. I want this to be included in the branch row group using the field from dataset1. So I used…
asked 2020-08-17T07:08:40.137+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, 31%, 34%)' 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)
meddojeddo
1
Reputation point
commented 2020-08-18T02:56:01.017+00:00
ZoeHui-MSFT
34,581
Reputation points
1 answer
Regarding Always Encrypted concept
Hi, As everyone we are aware of the limitations on Always Encrypted concept like below. a. Look for unsupported query patterns in ETL and identify alternatives. eg:- 1. BULK INSERT INTO SELECT FROM TABLE. 2. Queries with filters like FirstName…
asked 2020-08-14T05:57:04.76+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, 54%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
Kartheek Vasantha
1
Reputation point
answered 2020-08-17T08:14:58.893+00:00
CathyJi-MSFT
21,111
Reputation points Microsoft Vendor
2 answers
Unable to create External table in Azure SQL / SQL (onpremise) using Azure Storage as Source
Hey Team , I am trying to create external table using Azure Storage as source. In Azure SQL , i am getting error : External tables are not supported with the provided data source type. In OnPremise DB , Incorrect syntax near 'EXTERNAL'. Please…
asked 2020-08-11T10:15:38.553+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(32, 55.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Arun Agrawal
1
Reputation point
commented 2020-08-17T00:59:52.023+00:00
Cris Zhan-MSFT
6,611
Reputation points
1 answer
Connection String from MYSQL Workbench
I want to save data from SQL to SharePoint List. But I am stuck in making connection string .Coz after making i have to save that data into sharepoint list daily Please Suggest
asked 2020-08-14T05:40:27.707+00:00
Shiv Sharma
1
Reputation point
answered 2020-08-14T07:20:35.997+00:00
Baker Kong-MSFT
3,796
Reputation points
4 answers
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
I require a specific version of SSDT for my development environment due to the limitations of server software and other collaborators' environments. It has to be exactly SSDT version 14.0.60629.0 for Visual Studio 2015. I can not find a place to…
asked 2020-08-07T19:50:07.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(214.4, 22%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JMac
1
Reputation point
answered 2020-08-14T03:14:20.227+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
Microsoft Sql Server Native client 10.0 :Operand type clash int is incompatible with date
Hello, We just migrated Database from Sql 2008R2 to Sql 2017 (Windows Server 2016) and one of our Crystal Report which we used to run was running fine. Report using Data parameter (@Startdate and @Endate) but we are getting error: [Microsoft Sql…
asked 2020-08-07T22:43:07.947+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(150.4, 17%, 24%)' 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)
pdsqsql
411
Reputation points
commented 2020-08-13T09:55:16.463+00:00
CathyJi-MSFT
21,111
Reputation points Microsoft Vendor
3 answers
(2016) Exam 70-764 SQL Server Admin certification
As (2016) Exam 70-764: Administering a SQL Database Infrastructure will expire on 01/31/2021, what certificate will replace it and when can i take new certification exam. Thanks
asked 2020-08-08T13:47:23.25+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, 82%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Muhammad Khan
1
Reputation point
commented 2020-08-11T01:07:36.553+00:00
m
4,271
Reputation points
2 answers
we hope Microsoft can develop databases like mysql
We would like to provide the installation version and the installation free version; MySQL only needs to read the configuration file to run without complex registry key.
asked 2020-08-08T09:49:09.703+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, 19%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
kim wu
1
Reputation point
answered 2020-08-10T02:01:53.493+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
1 answer
Azure DevOps Server and SQL
Azure DevOps Servers installs SQL as part of its install?
asked 2020-08-07T15:02:01.393+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(297.6, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
HAWORTH Dave
1
Reputation point
answered 2020-08-07T15:08:03.76+00:00
Vaibhav Chaudhari
38,671
Reputation points
3 answers
Power BI paginated report on a local Power BI server to publish on Share Point online
Hi, I have a paginated report on a local Power BI Server. It works fine. I want to show this report on a Share Point Online page as a web part. I am getting an error regarding the URL of the report that it is not valid. All the examples that I…
asked 2020-08-04T09:16:38.153+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(163.2, 63%, 25%)' 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)
Sedso
1
Reputation point
answered 2020-08-07T06:32:58.497+00:00
ZoeHui-MSFT
34,581
Reputation points