Content
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!


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…


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…


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:…
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.…


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…
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
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.


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…


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…


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.


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…


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


how do i launch an app to play store
i just need 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:…


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?
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…


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…


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…


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?

