20,157 questions with SQL Server-related tags

Sort by: Updated
0 answers

Need hands on help with SQL server availability

I need on hands help diagnosing SQL server availability

SQL Server Database Engine
asked 2025-03-14T17:07:03.9566667+00:00
David Svedberg 0 Reputation points
commented 2025-03-14T22:14:08.5533333+00:00
Erland Sommarskog 119.5K Reputation points MVP
1 answer

Get list of current active sessions and info

Hello, am aiming to set up a SQL 2016 Agent job that runs say every 15 mins and would like to email me if the Sessions count is greater > 10 where each Sessions have statuses IN ('RUNNING', 'RUNNABLE', 'SUSPENDED') and provide at least the following…

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,491 questions
asked 2021-08-11T22:27:49.627+00:00
techresearch7777777 1,961 Reputation points
commented 2025-03-14T20:05:43.5133333+00:00
Balbeer Yadav 0 Reputation points
2 answers One of the answers was accepted by the question author.

SSMS Query Store Regressed queries - buttons don't have tooltips

Hi, I'm trying to analyze information in the Query Store. I started from the top report Regressed Queries which showed nothing for me, but I noticed that several buttons on the right don't have tool tips and it's hard to figure out what they are for. My…

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,491 questions
asked 2025-03-10T13:24:05.16+00:00
Naomi Nosonovsky 8,291 Reputation points
commented 2025-03-14T19:10:10.2566667+00:00
Naomi Nosonovsky 8,291 Reputation points
1 answer

Why do no nodes appear in summary

I thought it would have at least one node, but it didn't. Did I misunderstand its concept

SQL Server Database Engine
asked 2025-03-14T03:29:05.1+00:00
博雄 胡 545 Reputation points
answered 2025-03-14T16:49:16.7733333+00:00
Erland Sommarskog 119.5K Reputation points MVP
2 answers

Please Help me - How can I fix the 'Culture is not Supported' error when importing an Excel file to a database in SQL Server Management Studio

I have tried countless times to import an Excel file via the SSMS application interface and keep getting the below error. Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].[CovidDeaths$] ( iso_code] NV . "…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 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,491 questions
asked 2023-07-14T09:26:27.05+00:00
Nnamani Chisom Promise 35 Reputation points
commented 2025-03-14T13:13:37.65+00:00
Daniel Odoh 0 Reputation points
11 answers One of the answers was accepted by the question author.

Operand type clash nvarchar

Testing our web app after column encryption is giving us the error below when we try to update an encrypted table. The error message refers to nvarchar(4000) being incompatible with nvarchar(20). In the table being updated we do not have an…

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,491 questions
asked 2020-12-29T16:59:42.13+00:00
David Chase 681 Reputation points
answered 2025-03-14T13:07:59.7733333+00:00
santosh lokhande 0 Reputation points
1 answer

Cannot install SQL Server Integration Project in SQL Server 2019

Running Windows 11 Enterprise, version 23H2, OS Build: 22631.4890. Running new installation of "Visual Studio Professional 2019" v16.11.45 SQL Server Integration Services Projects extension - Setup Failed. "Fatal error during installation…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,664 questions
asked 2025-03-13T22:42:03.2633333+00:00
MarkDAgosta-2552 0 Reputation points
answered 2025-03-14T01:24:20.1366667+00:00
ZoeHui-MSFT 41,291 Reputation points
1 answer

Msg 15871, '@@FETCH_STATUS' is not supported.

I am running a query and have @@Fetch_Status while loop, but the query stops at the while loop and gives the error: Msg 15871, Level 16, State 6, Line 43 '@@FETCH_STATUS' is not supported. Not sure what the problem could be. Please assist.

SQL Server Database Engine
asked 2025-03-13T09:10:12.8566667+00:00
Lufuno Sape 0 Reputation points
commented 2025-03-13T22:54:51.4533333+00:00
Erland Sommarskog 119.5K Reputation points MVP
0 answers

Table Name: Order1 OrderId: Order's id OrderItemId: Item ids of the purchase orders. QuantityOrdered: Number of items Ordered for an order. ItemPrice: Order total value PromotionDiscount: Discount of an Order. batch_id: Batch id of the order. (Note: Us

Click on "Console" at the top right corner. Agree to the terms of service and click Continue. Search for "bigquery" on the search bar at the top. Click on "Create Project" Give the project a name you like. Click on…

SQL Server Database Engine
asked 2025-03-13T16:22:56.8033333+00:00
vamshi k 0 Reputation points
commented 2025-03-13T22:51:30.87+00:00
Erland Sommarskog 119.5K Reputation points MVP
3 answers One of the answers was accepted by the question author.

SQL server collation issue while doing replication

SQL Server Database Engine
asked 2025-03-12T19:23:34.1766667+00:00
Saikiran Avanigadda (INFOSYS LIMITED) 20 Reputation points Microsoft External Staff
accepted 2025-03-13T22:35:24.8566667+00:00
Saikiran Avanigadda (INFOSYS LIMITED) 20 Reputation points Microsoft External Staff
0 answers

SSMS Startup. Package did not load correctly.

I have installed SQL server and SSMS. Upon starting SSMS i get the following error message. This is followed with about 4 other popup boxes saying things like “visual studio common IDE package” did not load correctly. Please help me diagnose this error.

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.
148 questions
asked 2025-03-11T22:56:29.6466667+00:00
Blake Judson 0 Reputation points
commented 2025-03-13T22:24:32.4566667+00:00
Blake Judson 0 Reputation points
0 answers

Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)

Ever since the last patching window, we have some scheduled jobs on SQL production that are intermittently failing, producing the error "Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)" The jobs run fine if they are not…

SQL Server Database Engine
asked 2025-03-12T17:43:23.67+00:00
Paul Lagasse 0 Reputation points
commented 2025-03-13T21:51:19.8733333+00:00
Erland Sommarskog 119.5K Reputation points MVP
2 answers

Unable to update connection credentials. Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller

facing issue with connecting sql server to power bi service, in desktop this is working properly and also able to refresh but in service getting error.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,664 questions
asked 2025-03-11T04:29:49.5633333+00:00
Nirmala Jawalkar 0 Reputation points
answered 2025-03-13T20:26:23.4+00:00
Irfan Mohammed 0 Reputation points
0 answers

Availability Group is not connecting through Listener

I have set up 2 SQL VMs on Azure with VPN we connect to those VMs and it is a single subnet , No Public IP is used. but the listener is only accessible from Node1 when Node1's Availability group is primary and the listener is not accessible from Node1…

SQL Server Database Engine
asked 2025-03-12T09:25:03.6133333+00:00
Saiju E 0 Reputation points
commented 2025-03-13T07:25:56.4633333+00:00
Saiju E 0 Reputation points
1 answer

How to find the installation file for an older version of SQL Server Migration Assistant?

I need to migrate an Oracle database to SQL Server, but the current Oracle version is 11g, which is not supported by the latest version of SSMA for Oracle. How can I install a version of SQL Server Migration Assistant that supports Oracle 11g? SSMA for…

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.
558 questions
asked 2025-03-13T05:19:50.34+00:00
Vinh Dang Khanh 0 Reputation points
answered 2025-03-13T07:05:46.0166667+00:00
Olaf Helper 46,281 Reputation points
1 answer

What is Microsoft Plan for upgrading SSRS Report Viewer Control to Unified .NET platform

What is the Microsoft Plan for upgrading SSRS Report Viewer Control to Unified .NET platform? Link…

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.
3,010 questions
asked 2025-03-12T20:54:28.5033333+00:00
Ambar Prajapati 0 Reputation points
answered 2025-03-13T02:11:14.16+00:00
ZoeHui-MSFT 41,291 Reputation points
0 answers

I cannot uninstall SQL Server 2022

I have the same issue when uninstall SQL Server 2022 Express Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052294 Start time: 2025-03-13 08:39:16 End time: …

SQL Server Database Engine
asked 2025-03-13T01:54:47.53+00:00
Khoi Phan Ngoc 10 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Server xp_copy_files security thoughts and able to specify files older than only?

Hello noticed somewhat of a new recent feature xp_copy_files (for SQL Server2019 & higher) which we have SQL Server 2022 (believe most things similarly were done previously via xp_cmdshell which had security concerns). Is it correct to say…

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.
148 questions
asked 2025-03-08T22:37:16.5733333+00:00
techresearch7777777 1,961 Reputation points
commented 2025-03-13T00:51:47.42+00:00
techresearch7777777 1,961 Reputation points
1 answer

In MS Access what is the maximum "length" of the field in a table with data type "long text"?

Hi, i cannot see the size of the field and i have difficulties entering data with length higher than 2500 as varchar (table from sql server). I increased the field size to 3000 but it is not working I connected to that table again thanks for any…

SQL Server Database Engine
asked 2025-03-11T16:15:50.7233333+00:00
commented 2025-03-12T21:40:01.3466667+00:00
Erland Sommarskog 119.5K Reputation points MVP
1 answer

SQL server 2022 Expression Edition installation problem

Overall summary: Final result: Failed: see details below Exit code (Decimal): -2147467259 Start time: 2024-08-27 01:31:06 End time: 2024-08-27 01:33:39 Requested action: …

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,491 questions
asked 2024-08-26T23:49:50.5066667+00:00
A B M Ariful Bari Khandaker 0 Reputation points
commented 2025-03-12T20:45:22.4766667+00:00
Harris Steinman 20 Reputation points