• Does the sqlagent service account have the authority to perform the wmi query?
• Does the sqlagent job step proxy account have the needed authority to perform the wmi query...

We have a couple of "data domain dedicated" sql stand alone instances ( std edtn ) that only serve as SQLAgent job scheduling environment.

A number of SQLAgent proxy accounts have...

• This reply was modified 1 year, 7 months ago by Johan Bijnens.

If I'm corrent you can use "Return 1" (or higher) to fail your ps script in sqlagent

ongoing for a while

Thanks for the feedback....

But the failed logins report from the extended events session is giving logins which have not been able to login. How will creating this extended events...

Track down these connections and search for the applications that do not end their transactions and not close their connections.

hint: "Logon monitoring in SQL Server and Azure Managed Instances...

Happy it worked out !

This is what I use:

param ([Parameter(Mandatory = $true, Position = 0)][string]$TargetSQLInstance) 
<#
[string]$TargetSQLInstance = $args[0]

Write-Host $('Host - Args count [{0}]' -f $args.count )
Write-output $('Output - Args count [{0}]'...

I only update SSMS to the appropriate sql server version it is supposed to support.

As SQL2022 is still a botch, we have no reason to implement SSMS19 yet. I just...

1. I like that policy

2. मलाई त्यो नीति मन पर्छ

3. Мне нравится эта политика

4. أنا أحب تلك السياسة

5. Sviđa mi se ta politika

6. 我喜欢那个政策

7. J'aime cette politique

8. Lubię tę politykę

9....

are you trying to use table valued parameters ?

In this case I would start splitting the comment based on a space.

check "Tally OH! An Improved SQL 8K “CSV Splitter” Function"

and process the spliter results for...

• This reply was modified 1 year, 7 months ago by Johan Bijnens.

In this case I would start splitting the comment based on a space.

check "Tally OH! An Improved SQL 8K “CSV Splitter” Function"

and process the spliter results for the number...

• It may have to do with the available I/O threads and throughput for a filegroup containing multiple files and / or the use of multiple filegroups in the database....

1. The first Full backup of a database, activates the need for LOG backups to keep the log file size under control. ( if the recovery model...