Today I received 2 new false notifications:

A user you are following, "Sue_H", has posted new content

A user you are following, "SQLDCH", has posted new content:

did you check the ( FREE ) Powershell solution dbatools provides which can copy the logins ? ( and a bunch of other SQLServer relatied management features ! )

I dislike linked servers (because of its unstable behaviour by nature )

Why aren't you considering a (scheduled or evan ad-hoc launch) SSIS  package ?

As far as I know, I haven't subscribed to the topics ( the mail states I follow the users. topics emails state "topic" )

Today I received 2 mails...

apparently it is getting worse 😉

Did you test and compare both queries execution plans?

In general, I prefer using JOIN ( and only switch to alternatives when proven way better for that given solution...

does the sql server service account have write access to the given path?

as my devs often say: 'the server must have had a hiccup' 😉

Let's hope SSC gets this fixed.

have you tried adding :
and ( ( b.balance > 10
          OR b.balance < 0 )
       and e.eligibility in ('F', 'R')    )     

First of all: keep calm
- What's registered in the SQLServer errorlog file ?

That info is to be found in msdb!

/*
Backup overview for current database
*/

Declare @BU_DbName sysname
Set @BU_DbName = db_name()

select ...

No input parameters have been defined for the itvf because of dynamic "where clauses needs" by the dev team
(otherwise I would have transformed it into a stored procedure in...