Microsoft Q&A

SQL Server

14,652 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

14,652 questions with SQL Server-related tags

Sort by: Updated
1 answer

Does Interactive authoring of the integration runtime have to be activated manually?

Hello! I just wanted to know if there's a way to automate the enabling of the interactive authoring of the AutoResolveIntegrationRuntime. Thanks!

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,839 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,255 questions
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.
2,600 questions
asked 2022-06-29T16:07:00.26+00:00
commented 2023-01-27T15:53:05.7033333+00:00
Marc Scirri 1 Reputation point
7 answers One of the answers was accepted by the question author.

Can you recommend a sql formatter?

Dear colleagues, Which SQL formatter would you recommend? In our organization, we have coding standards. My problem is, there are to many of them. As I am responsible for the repositories containing SQL, I want to enforce a single standard by…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
asked 2020-11-17T14:17:45.18+00:00
Chris Sijtsma 106 Reputation points
answered 2023-01-27T15:42:17.4866667+00:00
Liubov Bovan 0 Reputation points
2 answers

SSIS Custom Connection Manager

I`m trying to create a custom connection manager for SQL Server Integration Services 2019, this component already works in SQL Server Integration Services 2012, but, after converting to SQL Server 2019 and changing DLLs of the same version, when I use…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,839 questions
asked 2023-01-19T20:08:21.2066667+00:00
Josivan Laskoski 0 Reputation points
commented 2023-01-27T15:41:56.5933333+00:00
Telen Wang 80 Reputation points
0 answers

Where can I find R Package MicrosoftML to use with SQL Server 2022 Machine Learning Services?

Hi, I am in the middle of the testing phase within migration from SQL Server 2019 to SQL Server 2022. I am using Machine Learning Services in SQL Server 2019 and this part has changed with SQL Server 2022. I have followed the installation guide here:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
asked 2023-01-27T15:40:38.5666667+00:00
Stefan S 0 Reputation points
0 answers

Best way to handle product selection when creating a quote

We are on dynamics 8.2. When I am creating a record for a quote, it doesn't allow me to select a product at the time of the creation of the record. I have to save it without selecting a product and modify the quote to select the product I want to sell.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
asked 2023-01-27T15:33:18.8366667+00:00
Raz. Usmani 0 Reputation points
3 answers

SSIS package execution fails from the integration services catalogue - Failed to decrypt an encrypted XML node.

Hi, I've migrated SSIS packages from SQL 2014 to SQL 2019.  Software and tools used in the VM: Visual Studio 2019 SQL Server 2019 SQL Server Integration Services 15.0 Microsoft Connector for Oracle (SSIS Oracle connector) 15.0 And use Standalone SQL…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,839 questions
Microsoft Build
Microsoft Build
A Microsoft platform for building applications with Visual Studio and .NET on Windows.
367 questions
asked 2023-01-20T14:50:30.1366667+00:00
Raj T 21 Reputation points
answered 2023-01-27T15:18:24.04+00:00
Raj T 21 Reputation points
0 answers

SSRS report - Export hidden columns to Excel

Is it possible to export a report into Excel with some columns being hidden but not completely removed? Thanks

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,092 questions
asked 2023-01-27T14:55:58.4833333+00:00
Zolotoy 171 Reputation points
2 answers

Visual Studio 2022 SSIS cannot enable logging

Right-click Control Flow area. Select logging. In Containers, I see Package1, that is not the name of my package. There is no checkbox next to Package1. How do I get the correct package in Containers and enable logging.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,387 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,839 questions
asked 2023-01-26T20:11:26.6066667+00:00
John Eveland 0 Reputation points
edited an answer 2023-01-27T14:48:52.98+00:00
Yitzhak Khabinsky 19,846 Reputation points
2 answers

Cannot login into an SQL server remotely through ssms when using windows credentials. This reoccurs after exactly a week and stops after a reboot.

We have a SQL Server 2008 R2 which locks all remote windows connections after a week. We get this error message The target principle name is incorrect. Cannot generate SSPI context. Upon reboot, connections are successful but this reoccurs exactly…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
asked 2023-01-23T20:34:01.2366667+00:00
Eudias Kifem 0 Reputation points
commented 2023-01-27T14:03:24.7566667+00:00
Eudias Kifem 0 Reputation points
0 answers

Performance issues - Sql Server 2022 Standard Edition

Hi, I've been using SQL Server 2014 express to store data and interact with my C# applications on Windows 10 for different years. I wanted to do some test with Sql Server 2022 before upgrading to that version so I've installed the Evaluation Edition (all…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,387 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.
6,910 questions
asked 2023-01-27T14:01:43.71+00:00
Leonardo Azzari 0 Reputation points
5 answers

Jeremy Louder Define Version of SQL Server is Best For Developing Database

Jeremy Louder | I need To Develop Some Database in SQL Server 2012. I Might be Best SQL Server 2012 To Develop Database with Enhance Features.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
asked 2023-01-26T20:35:47.8066667+00:00
Jeremy Louder 0 Reputation points
edited a comment 2023-01-27T13:59:56.7733333+00:00
Erland Sommarskog 67,481 Reputation points Microsoft MVP
1 answer

Access primary database instance from read replica instance

Since we are starting to use read replica in our projects, we are going to migrate the our data retrieval procedures to read only database. But, we are doing the performance track inside that procedures that we are moving to read only DB and it is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
Azure SQL Database
asked 2023-01-27T12:04:45.9166667+00:00
Mathankumar Rajendran 0 Reputation points
answered 2023-01-27T13:48:34.0666667+00:00
Alberto Morillo 24,631 Reputation points Microsoft MVP
2 answers

Where is the #tmptable?

Dear All, I created a temp table by the following Select Statement. However, I was not able to find #tmptable in the Tables list in SSIS. Might I know where the $tmptable went? (84242 rows affected) Tables in Object Explorer

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
asked 2023-01-27T08:13:03.64+00:00
Anonymous
commented 2023-01-27T13:47:39.2966667+00:00
Anonymous
1 answer

how do i launch an app to play store

i just need answers

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
442 questions
Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
3,026 questions
asked 2023-01-26T15:21:54.4+00:00
KAMU JOSE 0 Reputation points
answered 2023-01-27T13:32:56.52+00:00
Olaf Helper 25,476 Reputation points
0 answers

I can`t import data from Streaming dataset by API

I am working in my Local Dataset and I need to add a new table, but this table is in Streaming Dataset. I am the owner of the Stream Dataset, but when try includ this table, the system show me that exist an error in the connection Technical Details:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
3,415 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
5,892 questions
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,559 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
5,270 questions
asked 2023-01-27T13:28:05.1733333+00:00
Saul Bohorquez 0 Reputation points
0 answers

SSRS - export to Excel and image size

I have a column with small images. They look fine in the Browser but in Excel they look too big: Browser: Excel: Image settings are the following: Any idea?

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,092 questions
asked 2023-01-27T12:47:36.75+00:00
Zolotoy 171 Reputation points
3 answers One of the answers was accepted by the question author.

SSRS 2019 Add New Data Source an error has occurred. something went wrong

Trying to add a new data source, and as soon as I click "new, data source" an error box pops up "an error has occurred. something went wrong. please try again" If I click OK under properties and name in the text box to add the…

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,092 questions
asked 2020-09-16T21:11:37.69+00:00
John Abel 211 Reputation points
answered 2023-01-27T12:42:29.8866667+00:00
Shoeb Shabibi 0 Reputation points
0 answers

Can we convert R script to M code (Power Query)

As we are having few scripts in R which we are consuming in another scope, as per the new scope that needs be migrated to M (Power Query). If so, are there any best practices to migrate existing scripts to M code. Do we have any tools that can be used…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,255 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.
8,462 questions
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.
2,600 questions
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
337 questions
asked 2023-01-27T12:38:18.8+00:00
Manohar Kondragunta 0 Reputation points
edited the question 2023-01-27T12:42:10.4366667+00:00
ShaktiSingh-MSFT 4,666 Reputation points Microsoft Employee
1 answer

An Unexpected error has occured

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "dga1app20rescs_RS_BlankTemp" requested by the login. The login failed. Login failed for user 'sa'. at…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,462 questions
Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
6,070 questions
asked 2023-01-27T11:56:33.8933333+00:00
Vivardhan Reddy Vedium 0 Reputation points
answered 2023-01-27T12:11:48.3533333+00:00
Olaf Helper 25,476 Reputation points
2 answers One of the answers was accepted by the question author.

how to change tabular mode to multidimensional model?

Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?

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.
992 questions
asked 2021-09-23T02:32:42.227+00:00
ismepopola 61 Reputation points
edited a comment 2023-01-27T11:54:22.1733333+00:00
Martin Belak 0 Reputation points