have a look here:

https://www.mssqltips.com/sqlservertip/5659/customize-sql-server-notifications-for-ddl-changes/

Another thing is a job schedule. It also has owner and it could be the ex-dba account.

it could be replication also ...

if it...

Mike, what is log_reuse_wait_desc  for this database in sys.databases?

select name, log_reuse_wait_desc from sys.databases where name=N'yoursmalldb'

"It Depends".  On my main production server,...

please, show result of the following from both PROD and TEST:

select name, value_in_use from sys.configurations where name like '%server memory%'

Disregard this question, a trigger could complete this request, I need a way to be notify when a new job has been created on my SQL Server.  Any ideas,...

it's worth to check the content of default trace which is enabled by default on all editions of SQL server 2005+

https://www.mssqltips.com/sqlservertip/1739/using-the-default-trace-in-sql-server/

check this article:

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/06/30/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle/

https://docs.microsoft.com/en-us/sql/ssms/register-servers/execute-statements-against-multiple-servers-simultaneously

see dateadd function

What is the target table?

Heap, indexed, columnstore, etc ?

database physical structure (files & related)

database configuration parameters (options & config)

database objects

data itself

imho

hi Stefan

I see two options:

• GUI-based powershell script with the given logic inside. Users will run it, provide answers and the script will save the data to a table.
• SSRS...

what would  "select @@version" return?