18,732 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers One of the answers was accepted by the question author.

Bacpac file won't restore due to columnstore indexes on columns with specific data types.

Situation: We are using Serverless Azure SQL Databases as projects. Afterwards we delete these databases but before we do that we create backups of the databases. We are using SqlPackage.exe (version: 162.3.566) to create bacpac files. Restoring bacpac…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-19T09:58:51.94+00:00
Mark van Eck 76 Reputation points
accepted 2024-07-30T07:46:04.19+00:00
Mark van Eck 76 Reputation points
3 answers

Database access in Microsoft SQL Server

I am using HAS_DBACCESS function to check if user has access to the database present in sys.databases. Customer is claiming that they have given access to all the database present in server but while check it using HAS_DBACCESS it is returning 0 (zero)…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-26T11:45:23.9833333+00:00
Jigar Zanzarukiya 0 Reputation points
commented 2024-07-30T07:34:08.6233333+00:00
Erland Sommarskog 107.4K Reputation points MVP
2 answers

error while running the ssrs subscription

library!WindowsService_3!1e50!07/29/2024-00:05:27:: e ERROR: Error processing data driven subscription 402299b2-b643-43ca-97f5-b6601e666103: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceCredentialSettingException: The current…

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,883 questions
asked 2024-07-30T05:02:27.8+00:00
sarma 0 Reputation points
answered 2024-07-30T06:25:48.32+00:00
ZoeHui-MSFT 35,556 Reputation points
4 answers

Share mailbox not same as desktop version, why?

Hi, would like to use internet version for my emails but the shared mailbox favorites doesn't act like the desktop version. Desktop version: instant notifications Web version: just takes forever, the main inbox mailbox is ok, but takes forever to see it…

Outlook
Outlook
A family of Microsoft email and calendar products.
3,451 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.
13,390 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,672 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,078 questions
asked 2024-07-18T15:05:18.8466667+00:00
James Champagne 0 Reputation points
edited a comment 2024-07-30T06:24:32.4233333+00:00
Faery Fu-MSFT 18,531 Reputation points Microsoft Vendor
2 answers

Cant download SQL Server Management Studio

I'm trying to download the SQL Server management studio for school but can't get it to work. I have done the setup download and it says the computer needs to restart to finish the download. I have restarted multiple times and when i go back to the setup…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
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,883 questions
asked 2020-08-29T02:42:05.227+00:00
Troy Carr 1 Reputation point
commented 2024-07-30T05:50:33.2233333+00:00
Niel Morgan Thomas 0 Reputation points
1 answer One of the answers was accepted by the question author.

Filter Tablix with LIKE and OR

With SSRS, I need to filter a tablix with a LIKE and an OR condition. For example: WHERE MedCampaign LIKE AffCPD_1224* OR MedCampaign LIKE AffCPD_1225* I tried the below suggestion I found, but this just returns the entire dataset. How should I go about…

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,883 questions
asked 2023-08-22T16:15:47.6533333+00:00
Dom 771 Reputation points
commented 2024-07-30T05:45:57.6866667+00:00
Hagar Greif 0 Reputation points
2 answers

OS and SQL server upgrade

What could be the best upgrade plan for MS SQL server 2012 and Windows server 2012?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,672 questions
asked 2024-07-23T12:00:18.7866667+00:00
AJCV 0 Reputation points
commented 2024-07-30T05:44:42.9333333+00:00
LucyChenMSFT-4874 3,470 Reputation points
2 answers

How can I find my SQL server License to upgrade Report Server Configuration Manager

Our version of Report Server Config Manager is on Evaluation. We license an Azure sql server from Office365 but I cannot find the license key. I need to upgrade the RSCM but it's requiring a key.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-22T16:24:00.86+00:00
Mt Rose Administrator 0 Reputation points
commented 2024-07-30T05:44:27.2633333+00:00
LucyChenMSFT-4874 3,470 Reputation points
7 answers One of the answers was accepted by the question author.

SQL Express 2019 - Can't remotely connect

I have a fresh Windows Server 2019 with a fresh copy of SQL Server 2019 Express. Windows Firewall is turned off. I installed under default (not named) instance, and have no problems connecting locally with SSMS 2019. However, I can't remotely…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2021-02-26T21:09:15.44+00:00
Hugh O'Donnell 101 Reputation points
commented 2024-07-30T04:27:38.8366667+00:00
Dave Mescher 0 Reputation points
2 answers

Looping through excel files

I am trying to load multiple excel files using for each loop container. In my 'Excel Connection Manger' I am accessing the data through 'SQL Command from variable'. I am getting an error message when I try to make the filename dynamic in the connection…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,532 questions
asked 2024-07-28T23:22:23.42+00:00
Ali Ahad 111 Reputation points
commented 2024-07-30T02:48:06.83+00:00
ZoeHui-MSFT 35,556 Reputation points
3 answers

can we analyize data in sql? how? please tell me

can we analyize data in sql? how? please tell me

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-27T10:39:26.8333333+00:00
adamrez 20 Reputation points
commented 2024-07-30T01:48:21.3366667+00:00
CathyJi-MSFT 21,136 Reputation points Microsoft Vendor
1 answer

TSQL returning the wrong calculation results

I'm very confused. I've been working on this for hours. I have a query: set @interest = @balance * power(1.0 + @curIrate / 365.0,@days) - @balance select @checkDate checkDate, @interest interest, @balance balance, @curIrate curIrate, @days days 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.
13,390 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,606 questions
asked 2024-07-29T22:30:04.77+00:00
OHPRS Admin 211 Reputation points
edited the question 2024-07-30T00:57:02.3466667+00:00
LiHongMSFT-4306 25,726 Reputation points
1 answer

Cannot create and start Extended Events session in Azure SQL Managed Instance

Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 25 Reputation points
commented 2024-07-30T00:47:00.78+00:00
Oury Ba-MSFT 18,026 Reputation points Microsoft Employee
1 answer

Azure SQL Server Entra ID only authentication in ARM

Greetings, I am trying to create an Azure SQL Server with Entra ID only authentication using ARM templates as the title suggest. However if I don't add the administratorLogin and administratorPassword fields for the classis SQL server admin, 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.
13,390 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,692 questions
asked 2024-01-25T11:44:18.1433333+00:00
Dimitar Grozev 60 Reputation points
commented 2024-07-30T00:36:33.8433333+00:00
Oury Ba-MSFT 18,026 Reputation points Microsoft Employee
3 answers

Always Encrypted" column in SQL server

I can't decrypt the "Always Encrypted" column in SQL server using the keys in azure key vault, I am using Go language for the process and I can't find any reference reagrding the decryption, please guide me to decrypt the data in SQL server,…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-27T14:31:40.0633333+00:00
Mohammed Izzath 0 Reputation points
answered 2024-07-29T21:53:19.7633333+00:00
Erland Sommarskog 107.4K Reputation points MVP
0 answers

Unable to connect to Azure Virtual Machine(VM) with SQL Server Analysis Services(SSAS) installed using SQL Server Management Studio(SSMS)

I'm trying to deploy an MSOLAP multidimensional cube, using Visual Studio, to Azure VM with SSAS installed. However, the deployment failed due to the following error Severity Code Description Project File Line Suppression State Error The project could…

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,265 questions
asked 2024-07-29T20:42:58.5333333+00:00
Sunny Juneja 0 Reputation points
1 answer One of the answers was accepted by the question author.

Issue creating Service-Based SQL Database in Visual Studio 2022

I am attempting to create an SQL Database in visual studio 2022: I get the following error: even though sql client has been added as a package reference: Any thoughts? thanks

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,900 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.
13,390 questions
asked 2024-07-27T06:44:54.7333333+00:00
John Dyson 20 Reputation points
accepted 2024-07-29T17:43:55.88+00:00
John Dyson 20 Reputation points
0 answers

How to Retrieve SQL Server Instance Details from SQL IaaS Agent Extension Using Azure CLI

Hello Azure Community, I am working with SQL Virtual Machines in Azure and using the SQL Server IaaS Agent Extension to manage my SQL Server instances. In the Azure portal, under the "SQL Virtual Machine" service, I can view detailed SQL Server…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-26T12:15:01.9433333+00:00
FERNANDO ARTERO SERRANO 0 Reputation points
commented 2024-07-29T16:23:44.6233333+00:00
Oury Ba-MSFT 18,026 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Does Microsoft Permit Access to Source Code

Our corporate auditors asked if I had access to SQL Server Reporting Services source code. I told them I do not, but they need to hear it from Microsoft. Can you state that for them please? Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-29T13:05:24.7966667+00:00
PhilCBowman-7252 20 Reputation points
accepted 2024-07-29T16:17:46.2633333+00:00
PhilCBowman-7252 20 Reputation points
2 answers

SQL audit (Server audit specification > SERVER_STATE_CHANGE_GROUP) log sa user instead DOMAIN\USERNAME

Hi all, I am testing audit for SQL Server currently running on a IAAS VM (Win server 2022, SQL Server 2022 CU14). I have created an audit which log file in a file. I have created a Server audit specification which include the action…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,390 questions
asked 2024-07-25T17:04:58.85+00:00
Alessandro Colombi 0 Reputation points
commented 2024-07-29T16:12:12.4433333+00:00
Alessandro Colombi 0 Reputation points