17,221 questions with SQL Server-related tags

Sort by: Updated
1 answer

Queries are getting locked with query_notification_% wait resource

Hello! We have a database with snapshot enabled and read commited snapshot set to ON. We also have query notification enabled and more then 3000 subscriptions according to : select OBJECT_NAME(object_id),* from sys.dm_qn_subscriptions where…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
asked 2024-02-07T17:44:35.8166667+00:00
Oleksii Filipov 20 Reputation points
answered 2024-02-08T21:41:01.9766667+00:00
Erland Sommarskog 97,951 Reputation points
3 answers

Syntax error with ODBC drivers and DATEADD

I am using ODBC drivers and DATEADD I just cant get the syntax right [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. SELECT DATEADD (month, -2, #2020-10-10 00:00:00#) FROM TblCalibItems;

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
asked 2022-04-14T22:34:10.553+00:00
JXWD 6 Reputation points
edited the question 2024-02-08T21:38:04.4866667+00:00
JamesTran-MSFT 35,531 Reputation points Microsoft Employee
1 answer

Issue with service broker not working after Always on Failover SQL Server 2017

Dear Experts, We have a CRM database that is configured as part of Always on AG and these databases were migrated recently from another set of servers. Service broker seems to work on only one of the nodes and it is not working after a failover. Even…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,507 questions
asked 2024-02-08T07:12:12.2266667+00:00
mo boy 396 Reputation points
commented 2024-02-08T21:12:45.2+00:00
mo boy 396 Reputation points
2 answers

My query produces to multiple duplicate results, any ideas?

We have a survey of 8 questions. These 8 questions are broken down into 8 database tables as the query below shows. Each question can have multiple results. For instance, it is like using dynamically generated rows where an employee enters an answer into…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,479 questions
asked 2024-02-04T19:28:31.75+00:00
Simflex 276 Reputation points
commented 2024-02-08T21:05:17.92+00:00
Simflex 276 Reputation points
0 answers

MFA when connecting Azure Sql via ssms

I have not enabled MFA, but when I try to sign in to Azure SQL Database via SSMS, it asks me for an MFA code. I logged in with my M365 account and checked the security info, and MFA was not enabled there. I am able to login to Azure portal without…

Azure SQL Database
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
4,967 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.
12,126 questions
asked 2024-02-07T18:12:56.2+00:00
Siva Prasad 0 Reputation points
commented 2024-02-08T20:00:09.67+00:00
Oury Ba-MSFT 14,661 Reputation points Microsoft Employee
1 answer

Question on Dimension Security in SSAS cubes

Dear Team, Looking for help on below technical knowledge. This question is for MSBI - "SQL Server Analysis Server " Is it possible to create a security for entire dimension in "dimension data" tab of "Roles" window. For…

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,226 questions
asked 2024-02-08T16:43:40.5433333+00:00
Prema Prabhu 0 Reputation points
answered 2024-02-08T19:55:55.2566667+00:00
Olaf Helper 38,106 Reputation points
2 answers

SQL Server install fails because it thinks my drive is compressed

When I attempt to install SQL Developer on my laptop I get a message that says: Please provide a valid location. The specified directory 'C:\SQL2022' is not valid because this directory is compressed or is in a compressed directory. Specify a directory…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
asked 2024-02-08T16:37:01.2133333+00:00
Thom Pantazi 0 Reputation points
answered 2024-02-08T19:51:07.1133333+00:00
Olaf Helper 38,106 Reputation points
0 answers

some residential ISPs unable to resolve Azure FQDNs for SQL Managed Instance connectivity

HI We have an Azure SQL Managed instance which is accessible over Azure VPN, lets say the FQDN for connectivity is > ourdatabase.test12345.database.windows.net We have users using local workstations that need access to the SQL DB, either via an…

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.
12,126 questions
asked 2024-02-07T15:57:04.12+00:00
LeonT 20 Reputation points
commented 2024-02-08T19:49:34.3066667+00:00
LeonT 20 Reputation points
3 answers

How to add external table with computed column in SQL project in Visual Studio

Hi Everyone, SSDT / Visual Studio expert is needed, right now In Azure SQL Managed Instance in database I've got External Table with Computed Column: CREATE EXTERNAL TABLE [ExternalTableSchema].[ExternalTableName] ( [MANDT] [varchar](3) NOT…

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.
12,126 questions
asked 2024-02-07T09:23:04.7733333+00:00
Piotr Siwka 0 Reputation points
commented 2024-02-08T19:27:51.1133333+00:00
Amira Bedhiafi 11,226 Reputation points
4 answers

in MS SQL Want to update Distinct Values

See this is my Tables; (my MS Sql Version is 2016) Create table #UTIL_VwBranch (RegionID INT, BranchID INT) INSERT INTO #UTIL_VwBranch VALUES(1001,1415) INSERT INTO #UTIL_VwBranch VALUES(1001,1416) INSERT INTO #UTIL_VwBranch VALUES(1001,1422) INSERT INTO…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
asked 2024-02-08T17:19:57.9866667+00:00
Aypn CNN 426 Reputation points
commented 2024-02-08T19:12:18.7633333+00:00
Javier Villegas 810 Reputation points MVP
4 answers

How to list all features installed without run SQL Server setup?

How to check which feature are installed without run the SQL Server setup? I mean, how can I list what was marked to install when running the SQL Server setup? That include Instance features and Shared Features.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
asked 2024-02-08T14:29:56.7166667+00:00
ahmedbark 0 Reputation points
answered 2024-02-08T18:49:07.16+00:00
Olaf Helper 38,106 Reputation points
1 answer

Get list Administrators - DISCOVER_XML_METADATA

Hi, Running an XMLA script to get all administrators of SSAS. See below. Do you have to be an administrator to run this script or is it possible to give the user that runs the script another role/access that do not give that user admin rights, but the…

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,226 questions
asked 2024-02-08T13:03:27.45+00:00
Stefan 191 Reputation points
answered 2024-02-08T18:49:02.3566667+00:00
Javier Villegas 810 Reputation points MVP
1 answer

Cannot connect to SQL Management studio 19.3

Hi Microsoft team, I have been trying to connect to the SQL server for a long time now and i have been getting error message cannot connect to.... How can i overcome this challenge?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 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,717 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,395 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,226 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
14 questions
asked 2024-02-08T16:10:07.1266667+00:00
Boluwaji Olusegun 0 Reputation points
answered 2024-02-08T18:46:21.67+00:00
Olaf Helper 38,106 Reputation points
3 answers

SSRS 2019 "The permissions granted to user '' are insufficient for performing this operation"

Trying to add/run a subscription to a existing SSRS 2019 report I'm getting the error below in the SSRS log file where the ONLY thing I changed was my actual login to Domain\username. ` library!WindowsService_0!2154!01/26/2024-14:28:03:: e ERROR:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 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,717 questions
asked 2024-01-26T20:10:05.35+00:00
Nenea Nelu 41 Reputation points
answered 2024-02-08T18:37:12.4733333+00:00
Javier Villegas 810 Reputation points MVP
1 answer

Mail could not be sent to the recipients because of the mail server failure. SQL Server smtp relay O365 Exchange Online

Please can you help with the configuration you used that resolved your the issue. Error is he mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-01-12T22:30:04). Exception Message: Cannot send…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
Microsoft Exchange Online Management
Microsoft Exchange Online Management
Microsoft Exchange Online: A Microsoft email and calendaring hosted service.Management: The act or process of organizing, handling, directing or controlling something.
4,015 questions
asked 2024-02-04T13:11:55.1266667+00:00
Lucas Igbins 0 Reputation points
commented 2024-02-08T18:35:11.03+00:00
Lucas Igbins 0 Reputation points
2 answers

How to find Windows OS version from SQL Server

Trying to find out the operating system version on some of the SQL Servers where I do not have RDP admin access yet I execute the SELECT @@Version TSQL command which returns: "Microsoft SQL Server 2014 (SP2-CU17-GDR) (KB4505419) - 12.0.5659.1…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,582 questions
asked 2024-02-08T16:15:33.94+00:00
Nenea Nelu 41 Reputation points
answered 2024-02-08T18:32:27.7266667+00:00
Javier Villegas 810 Reputation points MVP
3 answers

is restore of partial mdf file possible in MS SQL?

I have MSSQL configured with 1 database with 1 mdf file. This mdf file size is 1TB. I tried copying this mdf file outside of my virtual server. my file transfer failed at 10 GB. Is it possible to restore this 10 GB file to see partial data/schema in MS…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
asked 2024-02-07T16:03:06.8733333+00:00
Rooban 0 Reputation points
answered 2024-02-08T18:12:14.47+00:00
way0utwest 1 Reputation point MVP
2 answers

Daily Restore\copy an Azure SQL DB to a Azure SQL MI.

Exploring options to schedule a restore or copy an Azure SQL Database to a SQL Server on Managed Instance (MI). Both are located within the same subscription and resource group. I've encountered similar requirements for restoring production databases…

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.
12,126 questions
asked 2024-02-06T22:29:01.0133333+00:00
Anoop Noel Nakkala 0 Reputation points
answered 2024-02-08T17:59:24.27+00:00
Javier Villegas 810 Reputation points MVP
0 answers

How to export/import with existing endpoints?

Hi, I'm trying to export/import bacpac from sql server with private link in data factory with webActivity. I'm using this documentation :…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,933 questions
asked 2024-02-05T18:35:47.8566667+00:00
OGINTZ Marina 85 Reputation points
commented 2024-02-08T17:59:12.74+00:00
OGINTZ Marina 85 Reputation points
1 answer

Add another or stack a license on server 2022?

How do you add another or stack a license on MS server 2022? I bought a used recertified Dell R740 twin Zeon CPU's with total of 48 cores and 128 GB ram, and added 12 new SSD hard drives. I set them up as a Raid 10 to be used as a DC to replace our aging…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,126 questions
asked 2024-02-08T13:25:52.79+00:00
Chuck Morris 0 Reputation points
answered 2024-02-08T17:55:36.81+00:00
way0utwest 1 Reputation point MVP