18,637 questions with SQL Server-related tags

Sort by: Updated
1 answer

Questions about always on’s data synchronization method

Hello I am curious about data synchronization of secondary in always on. Secondary confirmed that the redo thread reads the log cache or redo log file and synchronizes it to the data file and index file. I have doubts about the synchronization method…

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,318 questions
asked 2024-07-20T04:10:57.85+00:00
MINJAE KO 0 Reputation points
answered 2024-07-20T08:16:35.53+00:00
Erland Sommarskog 106.5K Reputation points
5 answers One of the answers was accepted by the question author.

Is there a 64 bit SSMS?

I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…

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,318 questions
asked 2021-09-29T11:48:06.173+00:00
子明 李 21 Reputation points
answered 2024-07-20T03:12:09.32+00:00
JD N 1 Reputation point
2 answers

Bacpac file won't restore due to columnstore indexes on columns with specific data types.

Situation: We are using Serverless Azure SQL Databases as projects. Afterwards we delete these databases but before we do that we create backups of the databases. We are using SqlPackage.exe (version: 162.3.566) to create bacpac files. Restoring bacpac…

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.
13,318 questions
asked 2024-07-19T09:58:51.94+00:00
Mark van Eck 56 Reputation points
answered 2024-07-19T21:54:26.07+00:00
Erland Sommarskog 106.5K Reputation points
0 answers

MY SQL SERVER INSTALLATION ERROR

Hello everyone, I'm currently on Win11 Pro 23H2. I have installed and uninstall My SQL express couple times but having no luck in success installation. I didn't know the cause of this issue. Hope you guys could get me a possible fix Thank you and Best…

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,318 questions
asked 2024-07-19T14:04:23.9566667+00:00
Đình Khoa 0 Reputation points
commented 2024-07-19T21:42:05.3133333+00:00
Erland Sommarskog 106.5K Reputation points
1 answer

How to talk to a SQL Database in Azure Gov from a Teams chat?

How alk to a SQL Database in Azure Gov from a Teams chat?

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,318 questions
asked 2024-07-19T18:49:00.4066667+00:00
johon sahu 0 Reputation points
answered 2024-07-19T21:39:02.86+00:00
Erland Sommarskog 106.5K Reputation points
0 answers

Issue with SQL Server compatibility level 2022 and sp_executesql

One of our customers running SQL standard edition 2022 wanted to explore setting their database's compatibility level to 2022; but when they do this, at least one of our queries fails to return metadata. So they have to keep the compatibility level at…

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,318 questions
asked 2024-07-19T20:07:28.8033333+00:00
Eckels, Adam 0 Reputation points
commented 2024-07-19T21:37:09.9566667+00:00
Erland Sommarskog 106.5K Reputation points
1 answer

Cannot create and start Extended Events session in Azure SQL Managed Instance

Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…

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.
13,318 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 20 Reputation points
commented 2024-07-19T21:34:10.5+00:00
Aleksey Vitsko 20 Reputation points
3 answers

Database User dbo is orphaned- How to fix

Hello All All feedback is welcome ALTER USER [dbo] WITH LOGIN = [ww] GO Msg 15150, Level 16, State 1, Line 14 Cannot alter the user 'dbo'.

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,318 questions
asked 2024-07-18T14:38:25.7933333+00:00
Stephen Keogh 20 Reputation points
commented 2024-07-19T21:21:06.33+00:00
Ben Miller-(DBADuck) 10 Reputation points MVP
3 answers

VS2017 - SSIS Project

Hello Team, We are using VS2017 with SSDT installed (PFB the screenshot) We cannot find BI projects, unable to create SSIS projects. Please advice. Regards, Nagesh CL

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,869 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,666 questions
asked 2024-06-24T16:16:33.29+00:00
Nagesh CL 641 Reputation points
edited the question 2024-07-19T20:15:41.65+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
1 answer

Transcript Not Sowing Exam Passed May 9, 2024

When logged in here I can see Exam titleExam numberPassed dateAdministering Microsoft Azure SQL SolutionsDP-300May 9, 2024Administering Microsoft Azure SQL SolutionsDP-300May 9, 2024But the anonymous validation does not show it            …

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,318 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,666 questions
asked 2024-06-27T15:16:51.19+00:00
REGAN WICK 0 Reputation points
edited the question 2024-07-19T20:13:15.1466667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
3 answers

SQL login issue

I'm trying to connect via local SSMS to the SQL Server on my Azure VM but it's failing saying the Server is not found or accessible. I can RDP into my VM without issue. Any ideas please?

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,318 questions
asked 2024-06-10T10:03:55.5233333+00:00
Gurpreet Khaira 0 Reputation points
commented 2024-07-19T20:08:19.6966667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
1 answer

Additional Cost for Verify Function in SQL DB Backups to Blob Storage

I have a plan to move my SQL backups directly to Blob Storage and want to know what additional costs I may encounter when using the Verify function in my T-SQL query. I have read that Verify may increase costs tenfold, but I need more detail and…

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,335 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,615 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,318 questions
asked 2024-06-06T20:53:53.0733333+00:00
Jordan Algar 0 Reputation points
edited the question 2024-07-19T20:06:58.1666667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
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.
13,318 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 51 Reputation points
commented 2024-07-19T18:06:09.3933333+00:00
Janya Lee Erwin 246 Reputation points
3 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.
899 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,318 questions
asked 2023-03-13T10:37:19.7733333+00:00
adam900331 50 Reputation points
answered 2024-07-19T17:23:40.62+00:00
Mame Meier 50 Reputation points
1 answer One of the answers was accepted by the question author.

Getting errors trying to import data from an SAP Cloud for Customer tenant using OData API in SSIS

Hello, So, I am attempting to import data from an SAP Cloud for Customer (C4C) System into an SQL Server Table using SSIS on Visual Studio 2022. I am using the Odata Source tool to connect to the system and the connection is successful. I can even see…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,869 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,318 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
asked 2024-07-18T15:55:39.1166667+00:00
Amogh Sharma 0 Reputation points
accepted 2024-07-19T15:09:19.19+00:00
Amogh Sharma 0 Reputation points
3 answers

[Error] SQL Server closes automatically when trying to import files into a database

Hello! During the process of importing files into a database ("Tasks" > "Import flat file" > "Browse"), SQL closes automatically. It doesn't display any error message, it just closes. I've already uninstalled all the…

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,318 questions
asked 2024-07-16T09:29:00.7333333+00:00
Martin Mulloschadt 0 Reputation points
commented 2024-07-19T14:01:58.3333333+00:00
Erin Stellato 631 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

SQL Server Reporting Services installer not found

All links from all versions of SQL Server Reporting Services are returning the error $set_redirect('https://www.microsoft.com/library/errorpages/smarterror.aspx?correlationId=$(cvToken)') Internal Server Error. The server encountered an internal error…

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,869 questions
asked 2024-07-16T19:50:17.82+00:00
accepted 2024-07-19T13:00:06.57+00:00
0 answers

Linked service authentication options for SQL Server are different amongst ADF within same subscription

In the same Azure subscription, I have several resource groups and each has data factories, however, the linked service authentication options are not the same among them, why? Here is an example: ADF1: SQL SERVER Linked service authentication…

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,318 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,128 questions
asked 2024-07-19T10:42:32.6633333+00:00
Gonçalo J P Carvalho 0 Reputation points
commented 2024-07-19T12:47:13.4266667+00:00
Nandan Hegde 31,346 Reputation points MVP
4 answers

Share mailbox not same as desktop version, why?

Hi, would like to use internet version for my emails but the shared mailbox favorites doesn't act like the desktop version. Desktop version: instant notifications Web version: just takes forever, the main inbox mailbox is ok, but takes forever to see it…

Outlook
Outlook
A family of Microsoft email and calendar products.
3,403 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,318 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,595 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,064 questions
asked 2024-07-18T15:05:18.8466667+00:00
James Champagne 0 Reputation points
commented 2024-07-19T12:20:56.4266667+00:00
James Champagne 0 Reputation points
2 answers

SQL Query Split

Hello, I have query with result like below pic, now i want to separate the value to 5 columns based on value of al, av, date, int and KB so the expected final result is 07/18/2024 17:47:35 , 1.415.174.0, 07/15/2024 00:00:00, False and 5040430. And also…

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,318 questions
asked 2024-07-19T03:07:46.9366667+00:00
Handian Sudianto 4,471 Reputation points
commented 2024-07-19T12:20:00.6966667+00:00
Yitzhak Khabinsky 25,726 Reputation points