Blogs

Speaking at SQL Saturday South Florida 2024

By

I’m heading to SQL Saturday South Florida 2024 next week. This is my second...

The Next Phase & A Fresh Start

By

As of June 1, I am no longer an employee at 3Cloud. I am...

How do you restore a SQL Server 2000 database in the year 2024?

By

A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I...

Read the latest Blogs

Forums

Cannot Force Encryption - SQL Will Not Take Cert

By amy26

Hi there, I have a sql server on government AWS and we're trying to...

SHOWPLAN documentation

By as_1234

The most recent documentation I can find is this https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms189602(v=sql.105) which is showing as...

SSIS task that runs a PowerQuery

By pietlinden

I already have a PowerQuery that reads and parses a table from a PDF...

Visit the forum

Question of the Day

Dropping a Logon Trigger

I created this trigger for testing on SQL Server 2022:

CREATE TRIGGER checksteve
ON ALL SERVER 
FOR LOGON  
AS  
BEGIN  
IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve'
 PRINT 'Steve logged in'
END;  
GO
Now I want to drop it. What do I run?

See possible answers