I always add such attributes to the action part of the ADD EVENT

CREATE EVENT SESSION [DBA_purpose] ON SERVER
ADD EVENT sqlserver.database_file_size_change (
ACTION ( sqlserver.client_app_name, 
 sqlserver.client_hostname, 
 sqlserver.database_name,...

A number of tools already use DRI information (FK) to build their internal data model. (entity framework etc...)

But if the current evolution of AI is the drive to - finally...

It's not the sqlagent service account, but the sqlserver service account that needs the auth to get to the file share !!

Don't just change the DBLevel !

Coordinate date and time of your action to the given software teams, so in case they should get alarms, they know about this all.

What is the actual error code you get when executing the sql statement ?

The service account of the target instance needs read auth on the backup share ( and location...

I read you've already prepared it using DMA.

You'll have to address your devs or software vendor(s) to have them test their apps against your target db level.

I would aim to...

If I remember well, a regular sqlserver instance needs a startup parameter to be able to handle databases which are hosted on a remote share.

Why on earth do you want...

• This reply was modified 1 years, 8 months ago by Johan Bijnens.

Did you check this article . https://techcommunity.microsoft.com/t5/azure-sql-blog/using-query-store-with-least-privileges-instead-of-db-owner-to/ba-p/775177

If relationship is 1 - 1 -> inner join

If relationship is 1 - n -> exists

Don't you monitor your connections (using XE) ?

"Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

Why not just schedule the TSQL statement in a sqlagent job?

or use a powershell jobstep to create the backup using sqlagent ( or scheduled tasks if for express edition )

are you querying cross domain ? ( add the domain extention ! )

I have to scan a bunch of servers for failed logins. As part of this process, I want to get the incoming host names. However, the SQL log file...

Thank you for the...

Start with avoinding functions in where clauses ! ( needs full ( index ) conversion before actual use )

Declare @RefTs datetime2(0) = dateadd(MM, datediff(MM, 0, GETDATE()) -...