You need to connect to the DAC session via SQLCMD or SSMS and then drop the trigger.

ADMIN:MyServer\MyInstance

DROP TRIGGER Trigger_ServerLogon ON ALL SERVER

Unsure how many people here use DBATools as it's not talked about much.

But the module maintainers and other users of DBATools all hang out in Slack (you can join via...

OK, so you have given us a BACPAC

Now explain clearly what it is that you need help with, based on this sample data.

As based on your original logic, I still...

SSAS required Windows AD auth to work, so it "could" be possible if you could get kerberos working and you can get kinit to store credentials in the Mac's credential...

An error occurred in your logic.

You would need to implement TRY/CATCH logic and in the catch block of the error, return the actual error details, using something like

            
March 24, 2023 at 9:11 am
            
#4164500

            
            
                                                
        

Between is inclusive, so Lunch will be any meal from 10:00 to 15:59 and Snack will be any meal from 15:00 to 18:59 according to your logic above, so you...

Logic should be something like this

((Successful Pick / Total Picks) * 100)

((Mispick / Total Picks) * 100)

((Zero Pick / Total Picks) * 100)

Does this work for you?

SELECT[AT].[Site_Name]...

Sounds like your going to need to rebuild all the system databases.

No way to repair the MSDB database as its all system controlled.

Obviously rebuilding all the system DB's is an...

If you want to use DTU based pricing, you need to know your workload first.

First you need to capture 4 metrics - "Processor - % processor time", "Logical Disk -...

Yes I would be changing the driver from the SNaC to OLEDB.

The native client has been depreciated for many years now and is no longer receiving updates and it doesn't...

Oh man never (unless it is a drastic data delete and a one off shrink) shrink the data file, your getting yourself into a shrink rebuild shrink cycle and that...

How are you determining that those databases are not synchronising?

Are any of the jobs failing?  Does the monitor job fail warning that a backup/copy/restore hasn't happened within the allotted threshold...

OK so you got a way to get to the 2nd...

Please show at least some working of the problem you have tried.

You could easily wrap the CHARINDEX/SUBSTRING combination in a CASE statement and where there is no second space return...

I would like to send you on an exploration mission here.

Firstly take a look at the documentation for CHARINDEX and SUBSTRING

https://learn.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/t-sql/functions/substring-transact-sql?view=sql-server-ver16

Using a combination of these functions you can easily get...