User can not log onto Azure Sql Server
Users are not able to log on to use SQL server. Only the Admin (JKLawAdmin) can access, and I forgot how I set him up.
Function on Column used in Index - need optimization advice
First, is this the proper forum for MS SQL tsql questions? Why am I seeing only 114 questions? OK, so we have a table ods_DDAHIS which has a TransDate column that is numeric in format YYYYMMDD. There is an index on ods_DDAHIS.Transdate. Then view…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
indic_general_90_ci_as was not found
I am trying to install SQL SERVER 2014 version but I am getting "indic_general_90_ci_as was not found" error. I have attached the screenshot of the error as well. Kindly help me how to fix this error. What does this error mean?
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
SQL Server Management Studio 18 Closes with a Worning Sound After Splash Screen
When I launch SQL Server Management Studio 18, the splash screen appears, but then it closes with a warning sound without any error messages. I get the same issue when i try to run it as an administrator. Can you help me? I'm using Windows 10 Pro and…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Session will not rollback after 5 days, stuck with LCK_M_SCH_M
I was doing some partition maintenance where I was switching partitions to a new table, renaming the old table and the new table (switching places) and then adding FK's and indexes to the new table to make it the same as the old. This was all done in a…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
High parallelism in Query Store.
Greetings. As you see in the screen shot the bulk of my wait time is going to one wait type. A few fun facts: This is in a reporting type DB with the bulk of activity coming from ETL and Power BI queries, no OLTP type stuff at all. Maxdop on the…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ?
How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ? I would like to write a query to get which CU is installed on my sql servers managed with Azure Arc. I don't find the exact product version. For instance,…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to find server name after installing SSMS 20.2?
I have installed SSMS 20.2 to my home computer but don't know what Server name to add. I saw on other forums to type a single dot, but it does not work. I chose Browse for more, but could not find anything under Local Servers. Thank you very much for…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to connect azure automation account to azure sql server which has private endpoint enabled
How to connect azure automation account to azure sql server which has private endpoint enabled
Are Group Managed Service Accounts supported with SQL Server Reporting Services
I'm wondering if Group Managed Service Accounts (GMSAs) are supported in SQL Server Reporting Services now. I opened a concierge chat to find out and I was told yes but the link I was sent said it wasn't supported.…
Deny URL access if link contains word "/cats" on IIS 10 for Report Server
Good day! I am writing with one question that has been bothering me for several months. IIS 10 and PowerBI Report Server are installed on our Windows Server 2019 server. Access to services is implemented via the URL:…
![](https://techprofile.blob.core.windows.net/images/51pO4CSkM0umU9NmDI4C9g.png?8D9736)
![](https://techprofile.blob.core.windows.net/images/CL9sTc5zkUClnOVlnXO8DA.png?8DCA31)
Store proc body with select and update
We have store proc in azure sql db which is having select and update statement, with select we don't have any issue but while updating if we are updating less then 14 rows then it's working fine but if we have more then 14 rows then it is not…
SSRS 2022 Embedded images not appearing when taskbar = False
Reports with embedded images work perfect when taskbar = true. However, the resources can not be found when = false. I've spent over 2 hours with ChatGpt troubleshooting logs and configuration settings. My wildcard cert is working perfectly. Both portal…
Build SSAS Tabular Daliy Partition from SQL Server
Hello Experts, We are using SQL Server and SSAS Services, have to automate the process of building daily partition on fact table (TMSL code mentioned below). this should be called from Stored Procedure. I have to code such a way to build daily partitions…
Build SSAS Tabular Daliy Partition from SQL Server
Hello Experts, We are using SQL Server and SSAS Services, have to automate the process of building daily partition on fact table (TMSL code mentioned below). this should be called from Stored Procedure. I have to code such a way to build daily partitions…
SQL Server bulk email issue.
There is a requirement to send the notification emails on every 1st and 2nd working day of every month to all the concerned users. Since we have SQL Server as our database, we are using SQL database mail to send the mails, which is connected with smtp…
SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…
SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…
SSRS Report Builder Expression Issue
I have a report builder expression that takes a condition and turns the background cell red on the SSRS report if the condition is true. Example: DateValue(Fields!print_date.Value), DateValue(Fields!ship_date.Value)) >= 2) However if the print_date…
An integration services catalog was not found on this server instance
Hi, One of our developers is getting the error in the title when trying to deploy an integration services package from his laptop using VS 2019. The SQL server is also 2019 (I think) We can confirm the catalog exists as other developers can connect and…