20,042 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

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.

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,314 questions
asked 2025-02-20T00:18:44.05+00:00
Tom Burke 0 Reputation points
1 answer

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…

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.
116 questions
asked 2025-02-18T21:38:57.8033333+00:00
Grossnickle, Brenda 100 Reputation points
commented 2025-02-19T23:06:08.5633333+00:00
Erland Sommarskog 117.2K Reputation points MVP
1 answer

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-19T08:38:06.2933333+00:00
Sudipto Deb 0 Reputation points
answered 2025-02-19T22:16:34.7233333+00:00
Erland Sommarskog 117.2K Reputation points MVP
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-19T13:01:06.3333333+00:00
Özge Doğan 0 Reputation points
answered 2025-02-19T22:11:42.0233333+00:00
Erland Sommarskog 117.2K Reputation points MVP
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-19T13:56:03.7066667+00:00
ElementZero 0 Reputation points
answered 2025-02-19T22:08:59.58+00:00
Erland Sommarskog 117.2K Reputation points MVP
1 answer

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…

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.
116 questions
asked 2025-02-19T17:12:20.9666667+00:00
chrisrdba 451 Reputation points
answered 2025-02-19T21:57:22.9633333+00:00
Erland Sommarskog 117.2K Reputation points MVP
2 answers

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,…

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
477 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.
14,490 questions
Azure Update Manager
Azure Update Manager
An Azure service to centrally manages updates and compliance at scale.
346 questions
asked 2025-02-17T19:00:55.1133333+00:00
Jean-Marie Roger 0 Reputation points
commented 2025-02-19T21:53:42.11+00:00
Erland Sommarskog 117.2K Reputation points MVP
2 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-16T12:29:22.3966667+00:00
Rade Rade 20 Reputation points
commented 2025-02-19T21:45:45.77+00:00
Erland Sommarskog 117.2K Reputation points MVP
0 answers

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-19T06:46:20.4933333+00:00
Yuvaraj Sonale 0 Reputation points
commented 2025-02-19T20:02:15.6366667+00:00
Mallaiah Sangi 5 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

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.…

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,996 questions
asked 2025-02-14T17:24:48.11+00:00
Robert Davidian 61 Reputation points
accepted 2025-02-19T19:39:11.2133333+00:00
Robert Davidian 61 Reputation points
1 answer

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:…

Internet Information Services
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,996 questions
asked 2025-02-18T19:24:05.1733333+00:00
Sergey Knyazev 0 Reputation points
edited a comment 2025-02-19T19:08:40.3033333+00:00
Lex Li (Microsoft) 5,852 Reputation points Microsoft Employee
3 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-11T15:36:10.77+00:00
Nikhil Somani 0 Reputation points
commented 2025-02-19T18:43:49.2533333+00:00
Mallaiah Sangi 5 Reputation points Microsoft Vendor
3 answers

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…

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,996 questions
asked 2025-02-11T14:20:29.3766667+00:00
Chris Polito 0 Reputation points
answered 2025-02-19T18:10:42.37+00:00
Jonathan Pereira Castillo 14,535 Reputation points Microsoft Vendor
2 answers

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 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,314 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.
14,490 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,314 questions
asked 2025-02-11T07:24:18.6333333+00:00
PANDEY Prashant 145 Reputation points
answered 2025-02-19T18:10:19.8033333+00:00
Jonathan Pereira Castillo 14,535 Reputation points Microsoft Vendor
2 answers

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 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,314 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.
14,490 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,314 questions
asked 2025-02-11T07:24:18.6333333+00:00
PANDEY Prashant 145 Reputation points
answered 2025-02-19T18:10:19.8033333+00:00
Jonathan Pereira Castillo 14,535 Reputation points Microsoft Vendor
4 answers

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
7,799 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
asked 2021-05-03T08:29:26.623+00:00
utsav mistry 1 Reputation point
answered 2025-02-19T15:57:16.3033333+00:00
Ramesh Donagam 0 Reputation points
6 answers

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 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.
14,490 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 61 Reputation points
commented 2025-02-19T14:46:42.1566667+00:00
Jeffrey Howard 20 Reputation points
6 answers

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 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.
14,490 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 61 Reputation points
commented 2025-02-19T14:46:42.1566667+00:00
Jeffrey Howard 20 Reputation points
2 answers One of the answers was accepted by the question author.

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…

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,996 questions
asked 2025-02-17T13:40:55.19+00:00
Karen Bashaw 0 Reputation points
accepted 2025-02-19T14:44:25.49+00:00
Karen Bashaw 0 Reputation points
2 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
asked 2025-02-17T08:47:10.6066667+00:00
Farid Ali 0 Reputation points
commented 2025-02-19T14:13:09.85+00:00
Farid Ali 0 Reputation points