Following is a partial list

sys.dm_exec_requests: Provides information about each request that is executing within SQL Server.

sys.dm_exec_sessions: Contains information about all active user connections and internal tasks.

sys.dm_exec_query_stats: Returns aggregate performance statistics...

Add raiserror or print to check which is the last step that your SP executed successfully.

check this link if it helps.

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/linked-servers/set-up-troubleshoot-linked-server

Sometimes it takes some time to sync altered passwords between AD and other servers. Ask your network admin about it.

Also, did you  restart the SSRS service after the password change?...

check this link for granting permission's

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16

Yes, that's correct. All the protocols are enabled on this instance.

TCP/IP...

-- Firewall

Also check which protocols are enabled on the SQL Instance.

If you do not want to use the current disks, you can add an additional disk separately and attach it to your VM that has managed instance.  Save the files...

We have a similar requirement, we have used a SSIS package to copy the data from a table in Azure to on-premise.

As an alternate method, Create two jobs that can...

Leo.Miller wrote:

All the databases on the DEV server are encrypted, but only two were restored from another server after being encrypted, and only these 2 restored databases are giving errors...

Check the following:

a) Facets in SQL Server Management Studio (SSMS):

In SSMS, you can navigate to the server instance, right-click, and select “Facets.” Look for the “Surface Area Configuration” facet, where...

@Ashini:

1. Define the DNS record.

It looks like step 1 is already completed.

2. Run MMC.exe from the Run command. It opens console.

Go to File, Add remove Snap-in, Select Sql server configuration...

Ensure that your module is developed using the same version of Python that is installed on the server while initial installation of the SQL instance.

Instead of C:\Temp, create a folder...

@ralahari:

Paste your query and execution plan with data if possible. Understand that, there are many variables that we need to look into to optimize a query

What type of application are you trying to support , OLTP or OLAP?

If OLTP,  combine both transactions and updated_transactions table into one. Add a new table TransactionType which differentiates whether...