SQL Server Engine topics

SQL installation error . Exit code 2068052377

RionKhan — Fri, 23 May 2025 17:22:32 GMT

Error Description:

Simple SQL Update Query behaviour changed based on table volume.

murusolai — Sat, 18 Jan 2025 00:24:27 GMT

Here is an interesting case for you, please read patiently to understand the simple update with strange behaviour.

I have a two table with very minimal records and i am joining with referential integrity to update the value from 1st table to the second table's column. the update Query behaved differently when records increased over a time. its very simple update Query and the results are very strange. I will brief the scenario step by step as follow.

Table 1: Warehouse

Cleanup of auto created statistics

KarolFerek — Fri, 13 Dec 2024 13:19:57 GMT

Hello everyone,

during annual database checkup i found that there were a lot of auto created statistics, which weren't used.

It seems that DBMS doesn't cleanup unused auto created statistic on his own.

i guess i can drop them with the following query:

DROP STATISTICS Schema.TableName._WA_Sys_XXXXXXXXXXXXXXXXXXXX

But i am still thinking whether it is safe, about impact on the performance.

Has anybody had any experience with that?

Need help SQL query performance issue

Lakshmikiranreddy — Wed, 11 Dec 2024 14:21:30 GMT

I am looking to help optimize the below select statement

I have created supporting indexes and updated statistics , the same query is taking 2sec in one database ( note that same table structure and same data on both tables ) but another database it's taking 95sec on the same server.

I compared the execution plan for both 2sec vs 95sec it's exactly matching . Any clue on why it's running faster on one database but taking lot of time on other database.

These tables not heavily fragmented and stats are up to date on both database.

These tables contains 200million rows. Another important note is that indexes is not playing any role here , with or with out indexes query is taking 95sec

declare @v_vch_cut_off_date date =cast( getdate()-10 as date)

Select

ztr.work_day,tlms.work_day,

ztr.from_zone,zl.travel_zone_name,

ztr.from_business_unit,tlms.business_unit,

ztr.from_process,tlms.process,

ztr.from_item_category,tlms.item_category

FROM dbo.t_zone_travel_report(nolock) ztr

LEFT JOIN dbo.t_lms_process_time (NOLOCK) tlms

ON ztr.wh_id=tlms.wh_id

AND ztr.employee_id=tlms.employee_id

AND ztr.start_tran_datetime >= tlms.start_tran_datetime AND ztr.start_tran_datetime < tlms.next_tran_startdatetime

-- AND ztr.log_id >= tlms.log_id AND (ztr.log_id < tlms.next_log_id OR tlms.next_log_id=999999999)

AND tlms.work_day >= @v_vch_cut_off_date

LEFT JOIN dbo.t_travel_zones_locations (NOLOCK) zl

ON ztr.wh_id=zl.wh_id

AND ztr.from_location=zl.location_id

WHERE (ztr.work_day >= @v_vch_cut_off_date OR ISNULL(ztr.work_day,'') = '' )

AND (

ISNULL(ztr.from_zone,'') <> ISNULL(zl.travel_zone_name,'')

OR ISNULL(ztr.from_business_unit,'') <> ISNULL(tlms.business_unit,'')

OR ISNULL(ztr.from_process,'') <> ISNULL(tlms.process,'')

);

Catch Error in a SQL Server Logon Trigger

akaraulli — Thu, 05 Dec 2024 19:46:26 GMT

I have written a Logon trigger in a SQL Server to control logon authorization.

ALTER TRIGGER [LOG_TRG_01] ON ALL SERVER WITH EXECUTE AS 'SA' FOR LOGON AS BEGIN if ORIGINAL_LOGIN() = 'sa' begin return; end; if ORIGINAL_LOGIN() = 'OMEGACAEVDEV1' begin -- not allowed to logon rollback; end; -- Insert Trail EXEC [OmegaCoreAudit].[OMEGACA].[P_ACC_UNF_TRAIL] 0, 'trail_details', 'ip', 'server', 'db', 0 ; END GO

It does (as expected):

OMEGACAEVDEV1 is not allowed to logon
OMEGACAEVDEV2 is allowed to logon
An audit event is inserted by proc P_ACC_UNF_TRAIL in a table for both users.

All three above I want to stay this way !

But I need to have error handling in it, so that in case of whatever error the login is allowed to login - but keeping a record on another table named SYS_ERROR_LOG (with error details). In this trigger I have intentionally provoked an error by "select 10/0"

The new trigger is:

ALTER TRIGGER [LOG_TRG_02] ON ALL SERVER WITH EXECUTE AS 'SA' FOR LOGON AS BEGIN BEGIN TRY if ORIGINAL_LOGIN() = 'sa' begin return; end; --provoke error select 10/0; if ORIGINAL_LOGIN() = 'OMEGACAEVDEV1' begin -- not allowed to logon rollback; end; -- Insert Trail EXEC [OmegaCoreAudit].[OMEGACA].[P_ACC_UNF_TRAIL] 0, 'trail_details', 'ip', 'server', 'db', 0 ; END TRY BEGIN CATCH Insert into OmegaCoreAudit.OMEGACA.SYS_ERROR_LOG ([LOGIN_USER_NAME], [DB_USER_NAME], [USERHOST], [IP_ADDRESS], [OS_USER], [BG_JOB_ID], [ERROR_DATA]) values ('LOGIN_NAME', 'USER_NAME', 'USER_HOST', 'IP', NULL, NULL, 'ERROR_MESSAGE'); END CATCH END GO

In the above code "if ORIGINAL_LOGIN() = 'OMEGACAEVDEV1'" represents a simplified version of a wider authorization process.

Problem:

CATCH is not working.
Both users are not allowed to logon ("Logon failed for login '[user]' due to trigger execution")
No record is written on table SYS_ERROR_LOG. I was expecting one for each user.

What can I do to fix this problem?

best regards
Altin

百家乐AI网址伙伴微【70411382】

70411382645 — Sat, 02 Nov 2024 06:52:48 GMT

为了充分实现 AI 为您的组织带来的好处，您的员工需要知道如何使用 AI 驱动的工具和服务以及如何将它们集成到现有的工作流程中。正如世界经济论坛《2023 年就业前景》报告所解释的那样，“培训员工利用 AI 和大数据在未来五年内位列公司技能培训优先事项的第三位，42% 的受访公司将把这列为优先事项。”无论您为员工建立了完善的培训框架，还是刚刚开始建立技能培养流程，验证您的培训计划是否与最新的技术技能保持同步都可能是一个挑战。

Microsoft 培训服务合作伙伴 (TSP)可以帮助您的员工快速培养这些尖端技能。TSP 教授可直接从课堂转移到工作场所的 IT 技能，并且提供：

在微软 AI 应用和服务方面拥有深厚的技术专长和经验。

根据您组织的需求和目标进行技能评估和定制培训计划。

由Microsoft 认证培训师 (MCT)教授的深入培训解决方案，以 Microsoft 官方课件和Microsoft Credentials为中心，使用Microsoft Learn的内容。

自主学习和教师指导的课程，以虚拟和面对面的方式进行，充分利用当地市场专业知识、视频、交互式实验室和 Microsoft 认证准备资源。

优先考虑人工智能训练至关重要

世界各地的 TSP 已帮助无数组织的员工提高 AI 和其他 Microsoft 技术的技能。查看Skillsoft和Sulava的以下故事，了解TSP 如何帮助学习者提高 AI技能。

Skillsoft：人工智能技能培训的全球性机构

TSP Skillsoft 的业务遍布全球，为 60% 以上的财富 1000 强企业提供服务，客户遍布 160 个国家或地区。Skillsoft 与 Microsoft 合作开发了AI Skill Accelerator计划，这是一种结合课程和培训的方法，旨在让员工做好准备，充分利用 AI 工具，包括 Microsoft Copilot 和 Azure OpenAI Service。作为 Copilot 的“零号客户”，Skillsoft 培训师非常了解如何帮助客户提高技能，因为他们已经通过相同的学习经历建立了自己的技能。

这项综合计划旨在加速贵组织将 AI 功能集成到业务中的能力，并使您的员工能够开发可直接应用于工作的实用 AI 技能。它包括面向业务客户的生成式 AI 工具、Skillsoft CAISY™ 对话 AI 模拟器、技能基准评估和可自定义的内容。Skillsoft 可以提升贵组织在 Microsoft 的 AI 应用和解决方案（包括 Copilot 和 Azure AI）方面的技能。

“我们最近在 Skillsoft 采用了 Microsoft Copilot，并启动了一项多步骤的 Copilot 支持计划，以帮助所有团队成员熟悉 Copilot，并了解该技术如何提高他们的日常工作效率。随着我们推进 AI 转型，我们正在利用我们的 AI 技能加速器计划来提升我们团队的技能，这证明了结构化支持计划的重要性，以充分利用 Copilot 功能和其他新兴的 GenAI 工具。”

—Orla Daly，Skillsoft 首席信息官 (CIO)

了解 Skillsoft 如何加速整个组织的 AI 技能建设的更多信息。

Sulava：人工智能技能培养的先驱

总部位于芬兰的Sulava是一家领先的 TSP，也是帮助组织采用 AI 的先驱。Sulava 与科技和工业公司 Indutrade 合作，为 Indutrade 员工提供持续的培训课程。在六年的时间里，Sulava 举办了 180 多场此类课程，涵盖了 Microsoft 的 AI 应用和服务、Office 365 应用和 Microsoft Power Platform 等主题，充分利用了现代工作方法和工具以及网络安全。培训课程满足了当前的技能需求，从而提高了效率和工作满意度，并减少了支持单量。

最近，合作范围扩大到包括 Sulava 的 Copilot 采用服务，促进 Microsoft 365 Copilot 的实施并提供持续培训，以确保 Indutrade 及其子公司能够有效地使用人工智能并更高效地工作。

“我认为我们选择 Sulava 提供这项服务非常重要，因为指望人们自己弄清楚如何使用人工智能太过分了。工作转型需要付出很多努力，需要支持和培训。 ”

—Jarmo Kaijanen，Indutrade 首席信息官 (CIO)

Connect Remote SQL server with SSMS issue

Yogesh_05 — Wed, 30 Oct 2024 09:44:27 GMT

I am trying to connect the SQL Server Remote user with SSMS but I face the below issue

TITLE: Connect to Server
------------------------------

Cannot connect to "blank_for_security"

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-53-database-engine-error

------------------------------

The network path was not found

SQL server connectivity issue

kaifkhan3007 — Wed, 30 Oct 2024 05:57:44 GMT

I am trying to connect to sqlserver using sqlcmd command line tool, but its failing.
Error logs on server side:
Date Source Message 10/29/2024 3:43:08 PM Logon Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: 48.216.198.190] 10/29/2024 3:43:08 PM Logon Error: 17836, Severity: 20, State: 17.

From client side
sqlcmd -S 3.14.36.201 -U svc_lightbeam_temp -P <> -d master
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection.

sqlserver details
Microsoft SQL Server 2016 (SP1-CU8) (KB4077064) - 13.0.4474.0 (X64) Feb 24 2018 13:53:17 Copyright (c) Microsoft Corporation Web Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

Issues in Installing SQL server and SSMS

ekechi2005 — Wed, 25 Sep 2024 04:13:25 GMT

Please, I'm new to SQL, and I'm having issues installing SQL server and SSMS into my system. I've tried virtually all the troubleshooting options that I saw on YouTube and yet, I'm not making any headway. Please, what next should I do?

Replication Snapshot not getting generated in MSSQL 2022 Standard Edition

AdityaGaur — Mon, 23 Sep 2024 07:48:03 GMT

Hi,

I am trying to setup replication of MSSQL database hosted on Windows (Master) to database hosted on Ubuntu (Slave). After configuring the Publisher agent on Master, when I try to run agent to generate snapshot and check status, it shows "Starting agent". It keeps on running endlessly even though the size of my test database is very small.

I have checked that master server is not having any heavy processes running on it. Has anyone faced similar issue as well and resolved it then please guide.

Thanks & Regards.
Aditya.

Powershell script running in SQL task

German_Lagomarsino — Fri, 20 Sep 2024 17:51:50 GMT

Hi, what I need to do is to be able to run a powershell script from a sql task. This script contains secrets that were saved with a specific user account, this is necessary since the script makes connections to the Internet and must be authenticated. From a Windows scheduled task I managed to get it to work but not from a SQL task. Is there something that needs to be taken into account for this to work??

Thank you very much!

SQL Server audit logs incorrect info on column object_name

GabiSarbu — Tue, 17 Sep 2024 13:26:12 GMT

Hi, during an audit check on database events, i have noticed that sometimes on DDL events, when temp tables are mentioned, sql server 2017 logs incorrect information on columns schema_name and object_name and the statement column proves this:

Moreover, on the two columns the info for the object on which the DDL was applied, is taken randomly, it may show the first table, or the second, making this difficult to prove the actions in case of audits:

Sadly, i haven't found this reported anywhere..

Trace sql server shutdown steps

Nitztrace — Fri, 06 Sep 2024 16:14:33 GMT

Is there any documented / undocumented trace flag to trace low level steps of SQL server shutdown, like SQL server receiving shutdown request (if possibile details about the soruce) , checkpoints and finaally shutting down ?

百家乐客服【微QGY889889】

krewsonvedijuwugopo — Wed, 21 Aug 2024 05:31:07 GMT

SQL Server 是一个关系数据库管理系统。它最初是由Microsoft Sybase 和Ashton-Tate三家公司共同开发的，于
Microsoft SQL Server
Microsoft SQL Server
1988 年推出了第一个OS/2 版本。在Windows NT 推出后，Microsoft与Sybase 在SQL Server 的开发上就分道扬镳了，Microsoft 将SQL Server 移植到Windows NT系统上，专注于开发推广SQL Server 的Windows NT 版本。Sybase 则较专注于SQL Server在UNIX 操作系统上的应用。

SQL Server 2000 是Microsoft 公司推出的SQL Server 数据库管理系统，该版本继承了SQL Server 7.0 版本的优点，同时又比它增加了许多更先进的功能。具有使用方便可伸缩性好与相关软件集成程度高等优点，可跨越从运行Microsoft Windows 98 的膝上型电脑到运行Microsoft Windows 2000 的大型多处理器的服务器等多种平台使用。

SQL Server 2005

SQL Server 2005 是一个全面的数据库平台，使用集成的商业智能 (BI) 工具提供了企业级的数据管理。SQL Server 2005 数据库引擎为关系型数据和结构化数据提供了更安全可靠的存储功能，使您可以构建和管理用于业务的高可用和高性能的数据应用程序。

SQL Server 2005 数据引擎是本企业数据管理解决方案的核心。此外 SQL Server 2005 结合了分析、报表、集成和通知功能。这使您的企业可以构建和部署经济有效的 BI 解决方案，帮助您的团队通过记分卡、Dashboard、Web services 和移动设备将数据应用推向业务的各个领域。

与 Microsoft Visual Studio、Microsoft Office System 以及新的开发工具包（包括 Business Intelligence Development Studio）的紧密集成使 SQL Server 2005 与众不同。无论您是开发人员、数据库管理员、信息工作者还是决策者，SQL Server 2005 都可以为您提供创新的解决方案，帮助您从数据中更多地获益。

SQL Server 2008

SQL Server 2008是一个重大的产品版本，它推出了许多新的特性和关键的改进，使得它成为至今为止的最强大

和最全面的SQL Server版本。这篇文章详细介绍了Microsoft SQL Server 2008中的新的特性、优点和功能。

微软的这个数据平台满足这些数据爆炸和下一代数据驱动应用程序的需求，支持数据平台愿景：关键任务企业数据平台、动态开发、关系数据和商业智能。

SQL Server的愿景

许多因素致使产生了信息存储爆炸。有了新的信息类型，例如图片和视频的数字化，和从RFID标签获得的传感器信息，公司的数字信息的数量在急剧增长。遵守规范和全球化的发展要求信息存储的安全性和在任何时候都可用。同时，磁盘存储的成本显著地降低了，使得公司投资的每一美元可以存储更多的数据。用户必须快速的在大量的数据中找到相关的信息。此外，他们想在任何设备上使用这个信息，并且计划每天使用，例如Microsoft Office系统应用程序。对数据爆炸和用户期望值的增加的管理为公司制造了许多挑战。

Microsoft 数据平台愿景提供了一个解决方案来满足这些需求，这个解决方案就是公司可以使用存储和管理许多数据类型，包括XML、e-mail、时间/日历、文件、文档、地理等等，同时提供一个丰富的服务集合来与数据交互作用：搜索、查询、数据分析、报表、数据整合，和强大的同步功能。用户可以访问从创建到存档于任何设备的信息，从桌面到移动设备的信息

Input error: -2146893008

admin1500 — Tue, 13 Aug 2024 18:54:05 GMT

I'm trying to understand what is causing this error. Can't find much information online.

From the error description it looks like a network issue however I need more info to come up with a solution.

DATE/TIME:      xxxxxxxxxxxxxx
DESCRIPTION:    A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: -2146893008, output error: 0).
COMMENT:        This is a Fatal Error In Current Process Alert. Please review immediately.
JOB RUN:        (None)

Regards

Brian

SQL Server Virtualization and S3 - Authentication Error

sjungers — Mon, 05 Aug 2024 16:14:24 GMT

We are experimenting with data virtualization in SQL server 2022 where we have data in S3 that we want to access from our SQL Server instances. I have completed the configuration according to the documentation, but I am getting an error when trying to access the external table. SQL Server says it cannot list the contents of the directory. Logs in AWS indicate that it cannot connect due to an authorization error where the header is malformed.

I verified that I can access that bucket with the same credentials using the AWS cli from the same machine, but I cannot figure out why it is failing or what the authorization header looks like. Any pointers on where to look?

Enable Polybase

select serverproperty('IsPolyBaseInstalled') as IsPolyBaseInstalled exec sp_configure @configname = 'polybase enabled', @configvalue = 1

Create Credentials and data source

create master key encryption by password = '<some password>' go create credential s3_dc with identity = 'S3 Access Key', SECRET = '<access key>:<secret key>' go create external data source s3_ds with ( location = 's3://<bucket_name>/<path>/', credential = s3_dc, connection_options = '{ "s3":{ "url_style":"virtual_hosted" } }' ) go

Create External Table

CREATE EXTERNAL FILE FORMAT ParquetFileFormat WITH(FORMAT_TYPE = PARQUET) GO CREATE EXTERNAL TABLE sample_table( code varchar, the_date date, ref_code varchar, value1 int, value2 int, value3 int, cost numeric(12,2), peak_value varchar ) WITH ( LOCATION = '/sample_table/', DATA_SOURCE = s3_ds, FILE_FORMAT = ParquetFileFormat ) GO

how to send SSIS redirected error rows to json/nvarchar column in sql sever table

dpatil1261 — Thu, 01 Aug 2024 19:13:37 GMT

I have SSDT transformation component where I have configured in case any truncation, send them to SQL server table. requirement is to capture error information, error code and other column info in json format. I know this can be achieved using script component, but looking for any code snippet.

SQL Server Management Studio

Shane1961 — Tue, 25 Jun 2024 06:43:16 GMT

Hello,

I am new to Sql Express. (2022)

So I have a few questions that would help me along, thank you.

I am programming in Visual Studio 2022.

1. Is it imperitive that I use SQL Server Management Studio to create MDF in SQLEXPRESS DATABASE ENGINE? OR, just use VS2022?

2. Do I need to utilise SQL Server Management Studio to create a Report Server Project (and have 'report run' feature functionality) OR, just use Visual Studio 2022?

3. Do I need to 'buy' a Server Certificate?

I have been using localdb and creating reports using a Report Server Project. But of course I can not get them to run under localdb. I have read and tried everything that I can. Besides creating a SqlExpress database server, I only managed to allow open the correct port in Microsoft Firewall Defender. Regarding permissions, certificates ect..., I am lost.

Any help and guidance is appreciated.

Many thanks,

Shane1961

login failed for user sa sql server 2022 on windows server 2022

Aman_Susanto — Mon, 24 Jun 2024 08:10:37 GMT

i got the login failed error for user sa, but not always

so I went to server properties - security - server authentication

change to windows authentication mode

and change again to sql server and windows authentication mode, and restart sql server. this happened when i upgraded to sql 2022,

I have Service Pack 13 installed, can anyone help?

Getting error message to connect with server

misbah7uddin — Wed, 22 May 2024 23:08:43 GMT

Hello! I'm getting this error messages while i am trying to connect to the server. I have restart the laptop so many times but it still showing the same messages. shall i uninstall it and reinstall it again? This's first time I'm getting