17,913 questions with SQL Server-related tags

Sort by: Updated
6 answers

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…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,769 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.
12,697 questions
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,798 questions
asked 2023-03-20T13:32:32.0233333+00:00
JediVernacular 10 Reputation points
answered 2024-04-25T13:25:33.28+00:00
Mathieu Vanden Hautte 0 Reputation points
0 answers

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…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,828 questions
Bing Image Search
Bing Image Search
A Bing service that supports searching for images and gets comprehensive results.
45 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.
12,697 questions
asked 2024-04-25T12:58:15.02+00:00
LRC1006 0 Reputation points
2 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-24T08:29:59.1+00:00
Alen Cappelletti 911 Reputation points
accepted 2024-04-25T12:49:30.06+00:00
Alen Cappelletti 911 Reputation points
3 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-02-28T11:25:16.1466667+00:00
Haresh Prajapati 20 Reputation points
commented 2024-04-25T12:28:25.7433333+00:00
Haresh Prajapati 20 Reputation points
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-25T11:46:38.41+00:00
Alaa Mh 0 Reputation points
0 answers

how to solve this problem? I want to download SQL server.

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.
12,697 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,119 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,245 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,155 questions
asked 2024-04-25T11:06:08.61+00:00
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-25T11:02:46.91+00:00
Shaun Gibbins 0 Reputation points
1 answer

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…

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,245 questions
asked 2024-04-24T14:37:25.1533333+00:00
Tina Douglass 1 Reputation point
answered 2024-04-25T10:46:05.7133333+00:00
Tina Douglass 1 Reputation point
1 answer

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…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,604 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.
12,697 questions
asked 2024-04-24T19:26:26.72+00:00
Mark DeMichele 0 Reputation points
commented 2024-04-25T10:04:52.81+00:00
Mark DeMichele 0 Reputation points
1 answer

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…

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,842 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.
12,697 questions
asked 2024-04-23T10:59:34.03+00:00
Yashwant Kumar Sahu 16 Reputation points
commented 2024-04-25T09:36:20.92+00:00
Yashwant Kumar Sahu 16 Reputation points
1 answer

Excel数据导入的问题

我在尝试把excel表格的数据导入到sql的表里,有什么办法可以把前100行导入到A表,101-200行的数据导入到B表这样一次性完成吗

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
asked 2024-04-25T08:26:54.83+00:00
Blue 20 Reputation points
answered 2024-04-25T08:47:36.64+00:00
ZoeHui-MSFT 32,736 Reputation points
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-22T06:34:16.5366667+00:00
王 荣 0 Reputation points
edited a comment 2024-04-25T08:06:39.0233333+00:00
MikeyQiao-MSFT 485 Reputation points Microsoft Vendor
0 answers

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…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,122 questions
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,030 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.
12,697 questions
asked 2024-04-25T08:00:03.7266667+00:00
Milan 56 Reputation points
2 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-19T06:14:14.86+00:00
Francois Timms 0 Reputation points
commented 2024-04-25T07:34:49.96+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-03-22T23:48:06.14+00:00
Yassir 201 Reputation points
commented 2024-04-25T07:17:03.4633333+00:00
Greg Low 1,485 Reputation points Microsoft Regional Director
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-12T13:43:30.3566667+00:00
Hilton, Tyler 0 Reputation points
answered 2024-04-25T07:15:54.6766667+00:00
Greg Low 1,485 Reputation points Microsoft Regional Director
2 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-24T18:57:32.9433333+00:00
techresearch7777777 1,766 Reputation points
accepted 2024-04-25T07:07:17.2066667+00:00
techresearch7777777 1,766 Reputation points
1 answer

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…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,828 questions
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,798 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,235 questions
asked 2024-04-24T20:48:56.4066667+00:00
Roberto Carlos Melgar Dorado 40 Reputation points
commented 2024-04-25T07:04:37.24+00:00
Greg Low 1,485 Reputation points Microsoft Regional Director
0 answers

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-25T06:59:41.2566667+00:00
Rachael 0 Reputation points
2 answers

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
asked 2024-04-24T12:17:54.3266667+00:00
sakib rahman 0 Reputation points
answered 2024-04-25T06:51:23.69+00:00
MikeyQiao-MSFT 485 Reputation points Microsoft Vendor