did you also try to use just the group name (without the domain information) ?

On a single instance SQL Server 2022 installation, you can find bcp.exe overhere: "C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn"

With multiple instances, it may be needed to actually provide the correct path...

You can only define and use one port for mirroring and always on (combined ! )

What error are you receiving?

How large is your (test) table?

What about indexes?

Please post DDL

A trigger is always handled in the scope of one transaction.

Cascading triggers ( as you implemented ) are handled in the scope of the same transaction.

So to get around your...

Homework, school assignment, ... try chat gpt

enable query store and get a good view onto what is going on.

check the SQLAgent.out file on your server as well as the ERRORLOG file of the SQL Server !

To figure out which CHAR s are in the string ... check this thread https://www.sqlservercentral.com/forums/topic/how-to-remove-special-chars#post-4157818

You should ask the author.

There is no benefit writing it like that, could even be a performance downside due to the potential less optimal plan due to the calculation/conversion that...

...
AND ( 
          (D.CLS LIKE '%'+ U.IND_TYPE '%'
   AND D.CLS_OPERATOR = 'IN'
   )
 ...

We use extended events to capture that data.

ref: https://www.brentozar.com/archive/2015/12/tracking-tempdb-growth-using-extended-events/

100 results is incorrect !

due to your query:

SELECT Description + ' ' FROM RawDataDescriptions FOR XML PATH(''))

it produces 1 row !

test it with the data of  Steves...

Just to get you back on track ...

How many rows do you expect from your nested select(s) ?

SELECT Description + ' ' FROM RawDataDescriptions FOR XML PATH(''))...