Hi,

maybe there is a difference between collection the data, and displaying the data in the report.

What kind of report do you use, pie  shart, table or something like that?

Good luck,

Andreas

Hi,

When you look around, there are two approaches. Tools with an agent, and tools without an agent. All tools bring some load, but usually, this load is negligible.

As my predecessors...

Hi,

yes of course, the entries in the table are from 2003. I think, the database was migrated many time to the newest version.

We did not dropped all users, because the...

Hm,

but the only exists in the view in the database, so this should be users, and not logins, or? Logins should exists on the server level, not in the database.

If...

Hi,

the users only exists in this view. I am not able to select them from sys.server_principals, or something like that.

So, I think they are orphaned, and so I am not...

Hi,

if I look at sys.database_principals, I am not able to see those users.

And, if I am not able to see the user, I am not able to drop them.

I think,...

Hi

just take a look at this stairway:

https://www.sqlservercentral.com/stairways/stairway-to-transparent-data-encryption-tde

Good luck,

Andreas

Hm,

I would delete your account and servername from your log.

Did you try to use the *.bak file to restore the database from a current backup from the link listet in...

Hi,

did you change the query window to SQLCMD Mode?

* 2. Open the script inside SQL Server Management Studio and enable SQLCMD mode.

* This option is in the Query menu.

And can...

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...