Are any of your tables partitioned?  The tables on the secondary filegroup could be partitioned, so the index is related to a partition scheme not a specific filegroup, you could...

as part of a DELETE operation, the database must check that there are no records in tables that are foreign keyed to it that have a value that would be...

I believe sys.syscomments is one of the old-style system views based on the SQL Server 2000 metadata.  They've been depreciated for years and years, but they are still there in...

if you're trying to search through stored procedures, functions, views, triggers, constraints, etc code for a string, you could use sys.sql_modules like:

DECLARE @SearchString NVARCHAR(80) = N'%ClaimPayment%'
SELECT...

you might be able to troubleshoot this with some other sys views:

SELECT tl.request_session_id, tl.resource_type, tl.request_mode, h1.TEXT AS request_text,
    wt.blocking_session_id, OBJECT_NAME(p.OBJECT_ID) blocked_object_name, h2.TEXT AS blocking_text
 ...

you'd also have to OUTER JOIN any tables linked off of Orders as well, so maybe:

--first half of union
FROM dbo.Account AS ACC
   INNER JOIN...

There seems to be 8 different Diags that have a count of 4 in this set, so if you don't want ranks repeated, you would randomly leave off 2 of the ones...

ENCRYPTBYPASSPHRASE / DECRYPTBYPASSPHRASE should work if you supply the same exact passphrase parameter, even across different versions of SQL Server, since that phrase is what's used to generate the symmetric...

You need both the login and the user setup.  Login is at an instance level, and user is at a database level.  If you use the built in role db_datareader,...

it should work if you make it a global temp table using ##tmp3, instead of #tmp3

the CASE expression will always return a value, it's not like executing something after an IF condition.

could you have done conditional OUTER JOINs?  I suppose it depends on the data type of OldValue and NewValue, but maybe something like this:

CREATE VIEW [dbo].[UserLogViewByDB]
AS

I thought credentials were only used for a process within SQL Server to access resources outside of SQL Server:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-credential
Since you're already using domain accounts to log into...