6,844 questions with SQL Server-related tags

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

how to see the effect of Enable Scalar UDF Inlining in query plan

hi, i read this artical https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver16 but could not reproduce  the following results , is ther any query or example on interent where i can see…

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,210 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.
63 questions
asked 2024-07-06T05:50:03.5633333+00:00
Rajesh Kumar Yadav 20 Reputation points
accepted 2024-07-07T07:08:13.7733333+00:00
Rajesh Kumar Yadav 20 Reputation points
3 answers One of the answers was accepted by the question author.

When i try to connect MSSQLSERVER server it doesn't appear and only the SQLEXPRESS server appears.

I've installed SQL2022-SSEI-Dev then installed the SQL2022-SSEI-Expr then the SSMS-Setup-ENU when i open the SSMS to connect a server i cant find DEV server and only the Express server appears. What's wrong and how to fix?

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,210 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
7 questions
asked 2024-07-05T01:05:50.22+00:00
ABDELHALEEM MOHAMMED 20 Reputation points
commented 2024-07-05T23:48:48.9033333+00:00
ABDELHALEEM MOHAMMED 20 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Server connection timeout after idle

I just set up on Azure a SQL Server (free tier) connecting to an .NET Core web app also on Azure. After 20 minutes the database goes idle. The first attempted connection to the database fails with the call stack below. The subsequent call works…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,345 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,210 questions
asked 2024-07-04T17:35:16.3733333+00:00
Patricia Davidson 20 Reputation points
commented 2024-07-05T16:37:31.1233333+00:00
Patricia Davidson 20 Reputation points
3 answers One of the answers was accepted by the question author.

Installing MSSQL on Surface Laptop 7 with Snapdragon

I know there's been questions in the past when the ARM based MacBooks launched but now that Microsoft is shipping more ARM devices with the new Surface Pro and Surface Laptop is there any updated way to install and run MSSQL? Is Docker still the best…

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,000 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,210 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,797 questions
asked 2024-07-03T15:08:36.85+00:00
CandidKilsborne 20 Reputation points
commented 2024-07-05T16:11:26.88+00:00
Bruce (SqlWork.com) 60,376 Reputation points
1 answer One of the answers was accepted by the question author.

side effects of giving permissions to run traces

Hi All, I would like to know the downsides of giving permissions to run traces in lower environments (DEV/QA/UAT). Our DB team has only two members: one supports PST hours, and the other supports IST hours. The PST resource is on leave for a month, so I…

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,210 questions
asked 2024-07-04T08:23:42.3466667+00:00
Sam 1,476 Reputation points
accepted 2024-07-05T06:12:59.86+00:00
Sam 1,476 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Server 2022 Import and Export Wizard & Microsoft.ACE.OLEDB.12.0

Hello All Please advise on what needs to be done to fix this error << The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine >> All feedback welcome Thanks Steve Microsoft SQL Server 2022 (RTM-CU13) (KB5036432) -…

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,210 questions
asked 2024-07-04T11:21:48.9433333+00:00
Stephen Keogh 20 Reputation points
accepted 2024-07-04T15:50:20.36+00:00
Stephen Keogh 20 Reputation points
1 answer One of the answers was accepted by the question author.

can I rearm sql server 2019 trial period? We need to change the server in October and purchase the correct licenses together but the trial time is running out now

We need to change the server in October and purchase the correct licenses together but the trial time is running out now

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,210 questions
asked 2024-07-04T08:57:15.2166667+00:00
Luca Guenzi 20 Reputation points
accepted 2024-07-04T09:38:10.54+00:00
Luca Guenzi 20 Reputation points
6 answers One of the answers was accepted by the question author.

Microsoft SQL Management Studio for Mac

Hi, Is there any Mac version for Microsoft SQL Management Studio? Where can I get it from? Thanks, Jassim

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,210 questions
asked 2023-04-27T10:10:32.4133333+00:00
Jassim Al Rahma 1,546 Reputation points
answered 2024-07-04T09:03:49.37+00:00
Hitesh81 1 Reputation point
3 answers One of the answers was accepted by the question author.

Why can't I install SQL server 2022 express edition?

I am using VMware fusion pro on my m2 macbook in order to run windows so I can use the windows version of visual studio 2022 for a school project. I need to use winforms and connect it to a database. When I try and download SQL server 2022 express…

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,210 questions
asked 2024-06-28T23:11:53.34+00:00
Angelos Pappas 20 Reputation points
commented 2024-07-04T01:13:47.28+00:00
Angelos Pappas 20 Reputation points
1 answer One of the answers was accepted by the question author.

Can I install SQL Server 2022 Express on Surface Pro 11？

After installing SQL Server 2022 Express on Surface Pro 11, the instance cannot start correctly.

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,210 questions
asked 2024-07-02T09:27:48.32+00:00
zxm9501 zxm 20 Reputation points
commented 2024-07-03T16:45:43.8566667+00:00
Erland Sommarskog 105.8K Reputation points MVP
3 answers One of the answers was accepted by the question author.

SQL Server command permission levels

Our COBOL IO modules use SQL Server commands to access table data. We are migrating to a new server and decided to tighten security by giving users minimum level permissions. This caused an issue because all of our IO modules use the TRUNCATE command to…

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,210 questions
asked 2024-07-02T13:10:17.5033333+00:00
Stephen Schleyer 60 Reputation points
accepted 2024-07-03T14:50:57.3166667+00:00
Stephen Schleyer 60 Reputation points
1 answer One of the answers was accepted by the question author.

Monitor Azure Arc-enabled Server Availability

Is there a way to monitor Arc-enabled Server availability using Azure Monitor? There is no metric alert available for arc servers. We tried using resource health alert but it is not triggered when the servers are stopped manually. Tried KQL based on…

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,973 questions
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
369 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,210 questions
asked 2024-07-03T10:25:28.4233333+00:00
SujinaSJ-1789 271 Reputation points
edited a comment 2024-07-03T14:44:02.9933333+00:00
SujinaSJ-1789 271 Reputation points
7 answers One of the answers was accepted by the question author.

Microsoft SQL Server Studio - Dark Mode

Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?

Azure SQL Database
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,825 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,210 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,592 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR 125 Reputation points
commented 2024-07-03T04:42:42.13+00:00
Harsh Sugandhi 0 Reputation points
2 answers One of the answers was accepted by the question author.

DPM 2022 installation: "SQL Server Management Tools not installed on this machine" error during install

Hy! I am deploying a DPM 2022 evironment. A have a separate SQL server and a DPM server. The SQL server has SSMS 19.0.1 (latest). I have installed this SSMS version on DPM server before install the DPM 2022. THE DPM installation show the following error…

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
894 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,210 questions
asked 2023-03-13T10:37:19.7733333+00:00
adam900331 50 Reputation points
edited an answer 2024-07-02T22:22:19.6333333+00:00
Jonas Hunziker 0 Reputation points
1 answer One of the answers was accepted by the question author.

Sporadic INSERT EXEC failed because the stored procedure altered the schema of the target table

Hi everybody, We're getting this error sporadically. The outer stored procedure has a table variable and it also has a temporary table called #Results which is used to hold results of another stored procedure, e.g. DROP TABLE IF EXISTS…

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,210 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,592 questions
asked 2024-07-02T15:54:40.36+00:00
Naomi Nosonovsky 450 Reputation points
edited a comment 2024-07-02T21:40:08.37+00:00
Erland Sommarskog 105.8K Reputation points MVP
3 answers One of the answers was accepted by the question author.

SQL Server data import connection issue

I am getting the following error message when trying to import data from an excel spreadsheet. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Microsoft OLE DB Provider for SQL Server) I am running SSMS v20.1 on…

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,210 questions
asked 2024-06-25T10:36:57.11+00:00
Keith Banbury 20 Reputation points
commented 2024-07-02T15:38:32.48+00:00
Keith Banbury 20 Reputation points
5 answers One of the answers was accepted by the question author.

How to pass multi value parameters in SSRS for the Oracle Database using OLEDB Connection

Hi , We have created a parametrized report that has to take multiple values. Created two data sets ( One for report Data Set and the other for report paramarter dataset) Below is the screenshot for report data set where :id is the parameter. …

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,855 questions
asked 2020-12-07T09:28:55.863+00:00
Rajesh Chittineni 141 Reputation points
commented 2024-07-02T10:44:12.81+00:00
Shirley 0 Reputation points
2 answers One of the answers was accepted by the question author.

Microsoft SQL Server Management Studio 2019 Server + CAL Question

I am using the free version of SMSS 2019 to setup and manage a local database. Also running locally, under the same user, is an application which connects to this database to write into some of its tables. Now I am constantly running into the 10GB data…

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,210 questions
asked 2024-07-02T05:32:34.14+00:00
Lumawu 20 Reputation points
edited an answer 2024-07-02T09:27:05.6233333+00:00
Dirk Hondong 871 Reputation points
3 answers One of the answers was accepted by the question author.

Migrate from DB2 to Azure Database for PostgreSQL/MySQL/MariaDB

Hi, Is it possible to migrate a DB2 database to Azure database for PostgreSQL/MySQL or MariaDB? Thanks for the helping and documentation to do this process. Cordially, Albeiro Jiménez López

Azure Database Migration service
Azure Database for MariaDB
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
Azure Database for PostgreSQL
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
asked 2023-11-02T16:25:02.83+00:00
Albeiro Jimenez Lopez 20 Reputation points
commented 2024-07-01T17:08:09.08+00:00
Uliana Philippova 0 Reputation points
4 answers One of the answers was accepted by the question author.

Getting error : to run a ssis package outside of sql server data tools you must install standard edition (64-bit) of Integration Services or higher

Hi Everyone, I developed a package in SSIS 2019, and now testing it by running it from the batch file getting an error: to run a ssis package outside of sql server data tools you must install standard edition (64-bit) of Integration Services or higher.…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
asked 2021-04-14T21:07:51.09+00:00
ajay rawat 116 Reputation points
answered 2024-07-01T13:56:28.59+00:00
Kim Anical 0 Reputation points