Exchange 15.20 "Mail sent to the wrong Office365 region. ATTR35"
I'm trying to send outbound emails in SSRS but I am getting the following error: "4.4.62 Mail sent to the wrong Office 365 region. ATTR35. For more information please go to https://go.microsoft.com/fwlink" I have contacted O365 support but they…
Using SQL Server Read/Write Image Ever Day With A Table
I've a case that need to save Image in database, than user can search/upload site(DB) to site(DB) ever day from winform. Every image size average 250kb - 350kb, The total usage with image perhaps growth 110GB/year without delete form database. I'll…
VIEW SERVER STATE vs DB role for DMV on master
Hi, I have a logging procedure that reads from the two tables on master: sys.dm_exec_connections sys.dm_exec_sessions I had to assign permissions to a group for correct execution: GRANT VIEW SERVER STATE TO [domain\mygroup]; but I didn't want…
Issue with Bulk import using BCP with data file name consisting non-English character
I attempted to bulk import data using BCP from a file with non-English characters in its name. Both files were accessible, yet the import failed. Renaming the file to "order.txt" and "order.txt.format" resolved the issue, allowing…
Inquiry on Course Material Usage in Online Series
I have found a YouTube series that explains the content of the course ‘20463-D: Implementing a Data Warehouse with Microsoft SQL Server’. It uses the course slides and code to assist with their explanations -we as viewers don't have an access for the…
How to find midpoint of a polyline
How would you calculate the x,y of the midpoint of a polyline with MS SQL Server? I can get start point and end point by using shape.STStartPoint().ToString() and shape.STEndPoint().ToString() An arbitrary point using…
analysis services pivot taking a long time to refresh
We have an analysis services object that we connect in excel for pivot tables. This has been running fine for 3 years. IN the past month it is taking very long to refresh and also prevents anything else in Excel from being opened (even outlook). What…
Using SSDT on a build server
I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…
Logic app to on-premise SQL server connectivity using service principal (Azure AAD)
Hi Team, Our Agenda is to connect On-premise SQL server using Logic app with SQL server connector. We successfully setup Azure AAD with On-premise SQL. Also, using SSMS we are successfully able to make connection to on-premise SQL using service…
Excel数据导入的问题
我在尝试把excel表格的数据导入到sql的表里,有什么办法可以把前100行导入到A表,101-200行的数据导入到B表这样一次性完成吗
The 'Publish and Subscribe' feature does not work on SQL Server2019 installed using Docker technology on Linux
Database server information : Linux (Rocky 9.1) , Podman platform install (A kind of docker technology),SQLServer 15.0.4033.1(2019),docker image downloaded from the microsoft website,The service startup command is: podman run --name mssql2019 --net=host…
How to handle Azure SQL Virtual Machine discovery and cost together with Azure DevOps Server?
Hello, I am looking for answers for the scenario when we install Azure DevOps Server on Azure Virtual Machine. In this scenario we have VS Enterprise licenses so we have Azure DevOps Server license with SQL Standard license covered. However Azure came…
SQL Server Express 2022 Reinstall
Hi I have a question regarding the install process of SQL Server 2022 Express. I was running the platform successfully. My laptop was then migrated to a different domain and SQL Server stopped working (folder rights). I subsequently uninstalled SQL…
How Can I set the right value according to comparison conditition
Hello, i have 2 tables , the first one is a referential of the quality services and the second is a historical tables as bellow the DDL : drop table if exists #oderstatus_quality create table #oderstatus_quality ( id int identity primary key, label…
DCI Client Level Reporting Not Available
Is there any plan to fix the following error: The item '/DCI/DCI_Client_Level' cannot be found. (rsItemNotFound) Get Online Help for the Digital Contact Data reporting at a client level? This error is consistent across many representatives and has been…
Syntax to PRINT the row counts using Dynamic SQL?
Hello, what would be the syntax to PRINT the row counts using Dynamic SQL (in my case here need to get the row counts via a Linked Server View) I would like to have this as a step in a SQL Agent job which after it runs it PRINTs the row counts in it's…
Error loading report.rdlc,Unable to copy bin\debug\
Good afternoon again, I have already searched for information online, but I have not been able to find the error. The error is the following: An error occurred during local report processing. The report definition has not been specified, the file is not…
My emails have completely disappeared off my iPhone and I can’t get it back
I believe since the update I can’t access my Hotmail account and it displays the above messages, I have tried deleting and reinstalling but that haven’t worked my emails say connection to the server has failed
SQL2022-SSEI-Expr setup file is not opening
I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA