Microsoft Q&A

SQL Server

14,828 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

14,828 questions with SQL Server-related tags

Sort by: Created
0 answers

issue in modifying transaction replication articles sql server 2022

While modifying an article in a transactional publication after saving I get this error that seems new to sql server 2022: Could not find any resources appropriate for the specified culture or the neutral culture. Make sure…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-08T14:23:22.6866667+00:00
Alessio Sammartino 0 Reputation points
1 answer

Select row based on 2 column values

Please I have this table that looks like the below(schema script in the post) The table when selected will look like the below I need to get the value in A(XCHGRATE) where my desired date falls between B(EXCHDATE) and C(EXPNDATE) In this case my date…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-08T14:05:03.7433333+00:00
Michael M.M. D'Angelo 96 Reputation points
commented 2023-02-08T15:30:11.0466667+00:00
Yitzhak Khabinsky 20,021 Reputation points
1 answer

Sql select most repeated value

Hi, I have a database called a “reader”, and a table called "dailyreader". The dailyreader has 6 columns and i am looking to create a query to select the most repeated values in all columns and show how many times has been repeated. Thanks,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
646 questions
asked 2023-02-08T13:31:04.7266667+00:00
M Simo 0 Reputation points
commented 2023-02-08T14:23:54.8833333+00:00
Yitzhak Khabinsky 20,021 Reputation points
0 answers

How to get Existed Key Which is more than 1 count compare to source Table

Hi All, Lets say I have two sets of table which is tb1 and tb2. How can write the SQL query to get entire rows from @tb1 if I comparing the keys(CHDRNO and RSKNO) which the @tb2 and the count is more than 1 matching keys. The keys is CHDRNO and RSKNO.…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-08T10:19:32.6066667+00:00
jn93 506 Reputation points
commented 2023-02-08T13:19:22.0133333+00:00
jn93 506 Reputation points
0 answers

Sql DB Backup

Hello, As we know from yesterday some azure resources is down for southeast asia region including SQL server. So can we know where azure sql db store the backup? Can we download the backup and attach to sql server onprem version?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-08T10:18:50.3833333+00:00
Handian Sudianto 1,246 Reputation points
0 answers

How to show new line in SSAS tabular model attribute

Hello there, I have values in SQL column as "Project Name: MSP \n\n Project Description: Billable \n\n Project Status: In Progress." I am using this field in SSAS tabular model as an attribute and need to show a new line instead of \n. How can…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,008 questions
asked 2023-02-08T10:01:26.6866667+00:00
Palash Aich 21 Reputation points
commented 2023-02-08T10:42:47.87+00:00
Olaf Helper 26,056 Reputation points
1 answer

ERROR: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse)

Hello, When I want to edit the configuration file at Package Configuration Wizard, I get this error: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse) Please refer to the…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,457 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
646 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: The period of time during which a program is being executed in a computer.
960 questions
asked 2023-02-08T07:25:00.0866667+00:00
syazwan amir 0 Reputation points
answered 2023-02-08T08:22:12.63+00:00
ZoeHui-MSFT 18,896 Reputation points
1 answer

Is an availability group listener a proxy?

Is a SQL Server availability group listener an application-layer proxy? In other words, which of the following methods does a SQL Server availability group listener use to get traffic to SQL Server instance?: Method A(non-proxy): SQL Server client…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-08T04:43:54.2866667+00:00
Michael Ross 0 Reputation points
commented 2023-02-08T14:11:01.3466667+00:00
Michael Ross 0 Reputation points
1 answer

Trying to install SQL Server

I have successfully downloaded SQL SMS and it is running, but when I try to download and install SQL Server 2022 it gets stuck during the installation process. I have tried both the Express and Developer versions. The program downloads but freezes at the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-08T01:16:24.94+00:00
Moin Uddin 0 Reputation points
answered 2023-02-08T06:45:27.18+00:00
Seeya Xi-MSFT 12,821 Reputation points Microsoft Vendor
1 answer

Can't login SSRS web portal with AADDS account on other VM in same VNet

I have two VMs on Azure in same VNet, VM1 is running SQL 2016 with SSRS. I can connect SQL services fine with domain account from the VM2 but SSRS web portal is not logging in with domain account. Local SQL server account logs in to SSRS web portal on…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,132 questions
Azure Active Directory Domain Services
asked 2023-02-08T00:06:03.19+00:00
Umair 0 Reputation points
commented 2023-02-08T15:14:18.93+00:00
Umair 0 Reputation points
1 answer

Hey I am new to SQL and trying to download the software but I keep getting this error code. Does anyone know how to fix it on parallels?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T22:32:16.1366667+00:00
Garcia-Gonzalez, Alex 0 Reputation points
answered 2023-02-08T06:14:48.66+00:00
Seeya Xi-MSFT 12,821 Reputation points Microsoft Vendor
2 answers

Quotename Error

I have the following statement and am getting an error near keyword 'end' Declare @Col Nvarchar(Max)= '' Select @Col +=Quotename(CAST(Datepart(Year, CAST([STARTDATE] AS DATE)) AS NVARCHAR(10)) + ' - Q' + (CAST(Datepart(Quarter, CAST([STARTDATE] AS…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T22:23:35.13+00:00
ojmp2001 ojmp2001 121 Reputation points
commented 2023-02-08T07:45:05.23+00:00
Olaf Helper 26,056 Reputation points
2 answers

SSIS tool tips are not disappearing VS2019 16.11.22

Various tags pop-up, seemingly at random, when I'm editing an SSIS package. They often stay there for quite a while always at the front of the screen as I move the VS window around. If I select another app, they disappear. In the case of this…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,457 questions
asked 2023-02-07T21:10:17.8966667+00:00
Nick Ryan 366 Reputation points
answered 2023-02-08T01:44:49.7133333+00:00
ZoeHui-MSFT 18,896 Reputation points
1 answer

Saving all sql server agent jobs

Hello, I know there is a powershell script out there to copy all sql server agent jobs (dbatools). Is there a sql script to backup (basically, script out all the sql server agent jobs) and copy them to a local folder? Example: If there are 10 sql server…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T19:35:06.5033333+00:00
Victor 66 Reputation points
answered 2023-02-08T01:56:50.79+00:00
PercyTang-MSFT 1,501 Reputation points Microsoft Vendor
1 answer

Microsoft Reporting Services PDF Rendering Extension 11.0.0.0 - What is the Release Date?

Can Someone please tell me how to find out the release date of: Microsoft Reporting Services PDF Rendering Extension 11.0.0.0 ? I have a PDF document that has the following as the producer. It looks altered (all Metadata except create date and PDF…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T19:34:01.4533333+00:00
RAS 0 Reputation points
edited the question 2023-02-08T08:22:39.72+00:00
Andreas Baumgarten 66,156 Reputation points MVP
1 answer

Design Access control in SSAS Tabular Model

Hi Everyone, I need some help to design the dynamic access control in SSAS tabular model. Below is the requirement: Row level security but access aggregate level data Using AD groups (AD groups contain the employee email address - UserId) Note: I…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,132 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
27 questions
Azure Role-based access control
Azure Role-based access control
An Azure service that provides fine-grained access management for Azure resources, enabling you to grant users only the rights they need to perform their jobs.
373 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,008 questions
asked 2023-02-07T17:42:26.6033333+00:00
Manikant Mahovia 41 Reputation points
answered 2023-02-08T06:24:32.19+00:00
Alexei Stoyanovsky 3,321 Reputation points
2 answers

Cannot get Project Values to display in Report Writer

I am relatively new to Report Builder and am encountering an issue getting data to populate in a test report I am making. Here is an example of what is created when I click to Run. Here is a small sample of the data being uploaded: Input Project Cost…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,132 questions
asked 2023-02-07T16:54:01.9133333+00:00
Dockter, Chloe 0 Reputation points
commented 2023-02-08T14:30:35.9033333+00:00
Dockter, Chloe 0 Reputation points
2 answers One of the answers was accepted by the question author.

MS SQL 2019 Developer Edition Download Link

Hi, I'm trying to find link for MS SQL 2019 Developer Edition. But all links lead to https://www.microsoft.com/en-us/sql-server/sql-server-downloads where SQL 2022 is. Where can I find link to download SQL 2019 Dev?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T16:31:34.9033333+00:00
Pavel.Dyachuk 136 Reputation points
accepted 2023-02-08T09:12:04.2166667+00:00
Pavel.Dyachuk 136 Reputation points
2 answers

How to cleanup Python directories Launchpad service

I have installed the Python 3.7 machine learning feature in SQL Server but the memory growth is huge after executing several Python scripts. When you execute a SQL job with a python statement the launchpad creates folders in the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
asked 2023-02-07T15:50:18.53+00:00
Eric Bezemer 181 Reputation points
commented 2023-02-08T11:35:50.8566667+00:00
Eric Bezemer 181 Reputation points
2 answers

Expression Field Does Not Word Wrap in Excel

I have an SSRS report created in Report Builder. When I use a report field as part of a formula expression, the column does NOT word wrap when exported to Excel. However, if I remove the expression and use just the report field, then the column does…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,132 questions
asked 2023-02-07T14:54:44.7533333+00:00
JP Swamy 0 Reputation points
commented 2023-02-08T02:09:52.2333333+00:00
AniyaTang 2,101 Reputation points Microsoft Employee