No removing the database from the AG, leaves the database in a restoring state on the secondaries.

So you will need to manually go in and remove it if you want...

Why are you sending the database to the vendor.

Do you have NDAs and data policies in place with them so they don’t go and mess about with your data?  This...

Yeah, you can use the alter table add constraint clause.

ALTER TABLE MYTABLE ADD CONSTRAINT PRIMARY KEY CLUSTERED (…..)

Then you need to look at the text it is running and hope you catch it at the right times.

From sys.dm_exec_requests CROSS APPLY to sys.dm_exec_query_text using the SQL_HANDLE or the...

Checkout sys.dm_exec_requests and the command column, that will give you if its a SELECT/INSERT/UPDATE/DELETE and more

Thanks Steve

2021-09-28 07:38 BST, forums->active topics took 10 seconds to render.

For me always between 10-15 seconds for that to render at all times.

There is a wide range of books available in the books section of the site which covers various topics.

But as the product is vast what particular areas are you looking...

How are you verifying SSRS is installed?

Are you sure you using ssrs2017 or above?

Check the services.msc and find the path the service is located in.

Found in the official documents

C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles

https://docs.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources?view=sql-server-ver15

You will need to look at a DML trigger, after update if the value of val for ID is true do an insert, else do nothing.

Something similar to the below

With my daily spam reporting I reported this by accident, can it be reinstated please

/forums/topic/sql-server-2016-express-will-not-install-message-oops-rrs-feed

Also what's with all the 504 gateway errors recently.  I know the "active topics" takes a...

You need to be careful with running msdn downloaded ent/std in dev as depending on your license agreement they can be deemed as prod licenses.

Appreciate you don’t want ent features...

No one will do your work for you.

What have you learned so far?  Show what you have tried, what is not working and you will find people are more willing...

If TCP1433 has been blocked coming in from the internet the error should stop, however that is assuming you are actually using 1433 as the port.

Verify the port your using...

Find the process which has the files locked.

Use something like handle.exe from the sysinternals suite of applications to find what application has hold of the files.

Then try again.