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…
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;
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…
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…
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…
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 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…
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…
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…
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…
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.
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…
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?
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:…
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…
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…
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…
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…
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 :…
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…