18,698 questions with SQL Server-related tags

Sort by: Updated
0 answers

Always Encrypted" column in SQL server

I can't decrypt the "Always Encrypted" column in SQL server using the keys in azure key vault, I am using Go language for the process and I can't find any reference reagrding the decryption, please guide me to decrypt the data in SQL server,…

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,095 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,365 questions
asked 2024-07-27T14:31:40.0633333+00:00
Mohammed Izzath 0 Reputation points
commented 2024-07-27T19:20:55.93+00:00
Erland Sommarskog 107.2K Reputation points
1 answer

can we analyize data in sql? how? please tell me

can we analyize data in sql? how? please tell me

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,365 questions
asked 2024-07-27T10:39:26.8333333+00:00
adamrez 20 Reputation points
answered 2024-07-27T10:51:09.3733333+00:00
Erland Sommarskog 107.2K Reputation points
0 answers

Why is Event ID 4624 with LogonType=8 Logged by lsass.exe on My SQL Server?

Hi, I am observing Event ID 4624 with LogonType=8 being logged on my SQL Server, and it appears that the lsass.exe process is responsible for this logon. This occurrence is triggering a rule in our Splunk tool, causing some issues. Why is the lsass.exe…

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,365 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,637 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
980 questions
asked 2024-07-27T07:37:23.7033333+00:00
Ali Refahiati 0 Reputation points
commented 2024-07-27T09:40:32.59+00:00
Erland Sommarskog 107.2K Reputation points
0 answers

Issue creating Service-Based SQL Database in Visual Studio 2022

I am attempting to create an SQL Database in visual studio 2022: I get the following error: even though sql client has been added as a package reference: Any thoughts? thanks

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,365 questions
asked 2024-07-27T06:44:54.7333333+00:00
John Dyson 0 Reputation points
4 answers

could not load file or assembly'Microsoft.data.sqlclient'

how to solve this error

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,650 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,419 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,888 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,365 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,651 questions
asked 2023-09-12T17:01:47.29+00:00
Niyati Savaliya 0 Reputation points
commented 2024-07-27T06:36:37.1666667+00:00
John Dyson 0 Reputation points
0 answers

Sys. center DPM 2019 ID 104 Details: Windows cannot verify the digital signature for this file

Hello everyone, who has encountered this problem Everything was working fine until now Recovery point creation jobs for SQL Server 2008 database have been failing. The number of failed recovery point creation jobs = 1. If the data source protected has…

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.
907 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,365 questions
asked 2024-07-26T12:59:47.91+00:00
Alex_Nick 81 Reputation points
edited the question 2024-07-26T21:15:53.8833333+00:00
Alex_Nick 81 Reputation points
1 answer

How can not find a record of my Microsoft certifications in learning

I earned my MCP in 2004 and MCTS in 2012. How am I able to see these certifications? My employer is requesting I 'connect' these certifications with their system and I do not see the certifications listed in my Microsoft account. This has been most…

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,365 questions
asked 2024-07-26T19:57:24.4833333+00:00
Thomas Travisano 0 Reputation points
answered 2024-07-26T20:50:14.3+00:00
Azar 22,355 Reputation points MVP
2 answers One of the answers was accepted by the question author.

Resource Governor questions.

https://www.sqlshack.com/sql-server-2014-resource-governor/ Greetings. I'm using the link above to configure Resource Governor. I run some queries to max out the RAM usage but my PerfMon counters dont elevate the way theirs do. I can see RAM usage…

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,365 questions
asked 2024-07-23T22:05:40.0066667+00:00
chrisrdba 361 Reputation points
commented 2024-07-26T20:37:58.4766667+00:00
chrisrdba 361 Reputation points
5 answers

Server is detected with Weak SSL/TLS Key Exchange on Port 1433 which is used by application SQLSRVR.EXE

The server is detected with Weak SSL/TLS Key Exchange on Port 1433 which is used by application SQLSRVR.EXE This is with reference to the compliance request – 198121 regarding the Vulnerability 38863 - Weak SSL/TLS Key Exchange. Qualys is detecting…

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,365 questions
asked 2022-07-13T09:47:48.43+00:00
Ankush Sanjay Harne 1 Reputation point
edited a comment 2024-07-26T20:05:29.4+00:00
Surya Padigala 0 Reputation points
1 answer One of the answers was accepted by the question author.

Custom Job schedule - every first Friday after 15 of the month - is it possible?

Good morning, Is it possible to create a job that runs only on first Friday after 15th of each month? I'm trying the following but the option seems to imply it would run every 15th month, not on the first Friday after day 15th:

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,365 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,601 questions
asked 2024-07-26T14:05:25.8166667+00:00
Naomi Nosonovsky 545 Reputation points
accepted 2024-07-26T18:33:32.51+00:00
Naomi Nosonovsky 545 Reputation points
0 answers

Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length

Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 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,263 questions
asked 2024-07-22T17:24:40.0233333+00:00
Michael King 0 Reputation points
commented 2024-07-26T18:29:13.0666667+00:00
NIKHILANETHIKUNTA 155 Reputation points Microsoft Vendor
4 answers

How to install ms sql server on Windows 11 arm?

Hi all, I have a macbook so I installed Parallels and Windows 11 pro (arm). But I have a problem to install MS SQL Server on it. It seems to be imposible. Can you help me with this? Thanks a lot.

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,365 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,994 questions
asked 2023-10-30T08:29:45.66+00:00
Shirase 76 Reputation points
answered 2024-07-26T15:39:27.2633333+00:00
Bruce (SqlWork.com) 61,731 Reputation points
5 answers

How to fix The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.

I am new to SQL and was trying to copy a database for a project. However, the commands didn't execute accounting to the error 'The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.' How do 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,365 questions
asked 2023-01-27T19:55:06.07+00:00
PRANAY KUMAR PANDEY 0 Reputation points
answered 2024-07-26T15:16:41.8166667+00:00
Modrall, Mark 0 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.
907 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,365 questions
asked 2023-03-13T10:37:19.7733333+00:00
adam900331 50 Reputation points
commented 2024-07-26T15:11:44.8633333+00:00
Mame Meier 50 Reputation points
2 answers

Database access in Microsoft SQL Server

I am using HAS_DBACCESS function to check if user has access to the database present in sys.databases. Customer is claiming that they have given access to all the database present in server but while check it using HAS_DBACCESS it is returning 0 (zero)…

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,365 questions
asked 2024-07-26T11:45:23.9833333+00:00
Jigar Zanzarukiya 0 Reputation points
edited an answer 2024-07-26T13:37:15.3533333+00:00
Zahid Butt 871 Reputation points
0 answers

SQL Server installation error.

When im trying to install SQL Server 2022 (developer 16.x) error occurs related to setup.exe I already tried to disable UAC, Windows Firewall and defender, fully uninstall SQL Server, clean registry and reinstall but got the same error. When im trying…

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,365 questions
asked 2024-07-26T11:54:38.6266667+00:00
avent 0 Reputation points
commented 2024-07-26T13:17:44.8166667+00:00
Erland Sommarskog 107.2K Reputation points
0 answers

Error while trying to update Always Encrypted column using a stored procedure

In our development environment, one dedicated machine is set as SQL Server Database server. All other development machines are connected to this server as clients using SQL Server Management Studio. Facing some issues after implementing "Always…

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,365 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.
69 questions
asked 2024-07-26T11:55:34.62+00:00
Usha George 0 Reputation points
commented 2024-07-26T13:15:08.9533333+00:00
Erland Sommarskog 107.2K Reputation points
1 answer

Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update

Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,888 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
194 questions
asked 2024-07-24T06:47:23.6766667+00:00
Mary T 0 Reputation points
commented 2024-07-26T13:04:12.7533333+00:00
Anna Xiu-MSFT 27,891 Reputation points Microsoft Vendor
4 answers

After migrating to Windows 11 - Cannot bulk load because the file could not be opened. Operating system error code 5 (Aaccess is denied)

I just moved to a Windows 11 PC and now when using SSMS and I try to do a Bulk Insert into a SQL 2017 database, I get this error. Cannot bulk load because the file could not be opened. Operating system error code 5 (Aaccess is denied) I can do the same…

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,365 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,994 questions
asked 2024-07-08T18:52:02.8866667+00:00
DoveConnieDES-3786 1 Reputation point
commented 2024-07-26T12:53:50.61+00:00
DoveConnieDES-3786 1 Reputation point
0 answers

How to Retrieve SQL Server Instance Details from SQL IaaS Agent Extension Using Azure CLI

Hello Azure Community, I am working with SQL Virtual Machines in Azure and using the SQL Server IaaS Agent Extension to manage my SQL Server instances. In the Azure portal, under the "SQL Virtual Machine" service, I can view detailed SQL Server…

SQL Server on Azure Virtual Machines
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,365 questions
asked 2024-07-26T12:15:01.9433333+00:00
FERNANDO ARTERO SERRANO 0 Reputation points