Create a SQL Server JOB using SSMS 20.X for a .dtsx package from the ssisdb server
I installed SSMS 20.X and understood the problems connecting to the instance: I am successfully connected. Now I would like to schedule a JOB with an integration services step (which I have done hundreds of times in the past)... but with SSMS versions…
Azure SQL Server Database serverless or Elastic pool
I'm just getting started with Azure SQL Database and have some questions about pricing. I currently have about 7 databases in use with a free student subscription plan for a development environment. Most of the databases are only used occasionally when…
SSIS - Flat File Destination Fixed Width Columns Appear to be Ragged
I am trying to create a flat file export, the spec is fixed width column, no headers or delimiters. There are 16 columns, the total width of all the columns combined is 624 characters. i have attempted two methodologies, both yield the same result where…
Could it be possible to restore the SQL Server 2005 database into the SQL Server 2019
I am using SQL Server 2005 from the year 2010. Now I am wishing to install SQL Server 2019 in the same machine. Is there any problem if I restore the previous version in new version ?
SQL 2016 Linked Server Problems
I am trying to setup a linked server connection to another DB running a non-MSSQL DB. On the local server the account I am using has Sysadmin right on the remote server the local DB account has what they call Admin rights as well. We have tried using…
Security update for SQL Server 2019 CU25
Hi, I would like to clear up some confusion regarding security updates for SQL Server 2019. If Security update for SQL Server 2019 CU 25 KB5036335 is pushed out by our System Engineers team to a server, does that mean it includes the Cumulative Update…
How do I fix Error when install SQL server standalone installation :SQL Server Setup failure. SQL Server Setup has encountered the following error: Exception has been thrown by the target of an invocation.
TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: Exception has been thrown by the target of an invocation.. For help, click:…
Performance Monitoring tools used for 4 hrs
Using Performance Monitoring tool to check on the performance of the database server. I cannot extend the duration to more than 1000 secs. What are the other options for performance monitoring so that I can get the data for 4 hrs
AKS deployed application to access on-prem server
Hi, I want to connect to on-prem sql server from a .net application which is deployed in AKS. We already have Azure relay/hybrid connection setup for the same, but that requires azure app service. I am looking for options to connect from AKS deployed…
Enterprise Report Server not showing Data Driven Subscriptions
We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…
Migrating On-prem Sql DB to Azure Managed Sql Instance
Hello, I have created recently Azure Managed Instance and looking some expert guidance as I need to restore on-prem Database first for testing but my database is in simple recovery mode as it's non-prod DB. Do I need to change recovery model to FULL then…
Auditing SSRS Administrator role events
We have multiple users assigned to Administrator role of our SSRS product. So, how shall we audit what those individuals have done with the power of Administrator role, such as changing folder/report securities, deleting/adding folders/reports etc..?
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
How can we access SQL Server hosted on on-premises from Function app
I am trying to access SQL Server hosted on Azure VM from Function app using python. But I am getting this error: Result: Failure Exception: OperationalError: (pyodbc.OperationalError) ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login…
We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work
Hi We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work. We have come across documention which says its has limitations onwiht regards to publisher/subscriber and…
How to troubleshoot “SQL Server is terminating because of fatal exception C0000005 . Error code 17311
We have a legacy version SQL Server MSSQL 2008 , where we are getting an error “SQL Server is terminating because of fatal exception C0000005 " SQL Service gets stopped frequently on every Sunday. Unable to find solution for the above error , can I…
Custom Hybrid Connection Manager
Hi, I would like to know if we can have a custom hybrid connection manager in .net core code. I would like to connect to on-prem sql server from a cloud deployed .net solution. I am using Azure app service /Relay/Hybrid Connection for the same. I would…
Exception problem
Hi, I've got issue due to this line below. reader = cmd.ExecuteReader(); Can it be owing to no record returned?