Hi,

is your database e-mail activated?

If yes, you only need 2 steps.

1. select your autogrowth events
2. mail the result of the query

   (I found this code in the internet, it's not build...

Hm,

I just tried to activate the query store, and everythings works fine.

But I got the CU27. Maybe you should install the latest CU and check this issue again.

Best regards,

Andreas

Hi,

can you show us the errorlog, when the error occours.

And, is it possible, that someone tries to login with the wrong credentials?

Kind regards,

Andreas

Hi,

this post is duplicated.

Please reply on this post:

https://www.sqlservercentral.com/forums/topic/login-failed-for-user-sa-sql-server-2022-windows-server-2022

Hi,

the SA login is disabled, but the user is still able to work with the sql server.

The sa login maybe the owner of the jobs, or the owner of some...

Hi,

I hope understand your question correct.

We got both, Linked Server via "SQL Server" and via "MSOLEDBSQL".

If we had to use the SQL-Server type, the name of the linked server target...

Hi,

we check our databases every day with dbcc. If you got an error, it will maybe...

Hm,

have you checked your errorlog, when your database changed to suspect mode. Was this the time, when the index maintenance run?

Or where some other events on the time, when the...

Hi,

we got the same result with sp_who2, but our sa account is disabled.

I think, if you put the account to disabled, nobody is able to use this account for login.

The...

Hi,

is your workstation and your SSRS in the same domain?

What is your security configuration?

Maybe you are not in the loca admin group?

Kind regards,

Andreas

Hi,

in the sql server properties you can configure the memory for the sql server.

Sample:

If your server got 24 GB RAM, let 4 GB RAM for the OS. You should configure...

Hi,

maybe we got the same error some year ago.

Can you run this query:

SELECT * FROM sys.dm_os_nodes

In our case, some nodes got the status " THREAD_RESOURCES_LOW".

The OS was...

Hm,

are you able to delete the old backup files if you run the script from the job manually?

If the job runs via sql server agent, it uses the sql server...

Hi,

it would be easier, if you can tell us the versions of the sql server, of the client workstation and so on.

Best regards,

Andreas

Hello,

maybe you are able to check the query from SPID 0

DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 0
SELECT TEXT
FROM sys.dm_exec_sql_text(@sqltext)

Good luck,

Best regards,

Andreas