gorandalf

Goran is a SQL Server/Microsoft Data Platform professional. He started working with the SQL version 6.5 many years ago and has worked in various DB-related roles from database administrator to database developer to Data Warehouse and BI architect. He's a member of the local chapter of PASS in in Munich, Germany and often attends SQL Saturdays and similar events in the region.

Blog Post

The value of mentoring

I’ve spent my whole career working with databases which is over 20 years and counting. I work for a great company and I love what I do. The job...

2020-08-28 (first published: )

191 reads

Blogs

The Community is YOU, Not Any Organization

By

As I type this, we’re leaving behind spring, and all the amazing events that...

Polyglot Persistence

By

I’ve seen the term polyglot persistence floating around Redgate a bit recently in the...

Six Months!

By

Oh good gosh. Six months without a single blog post. Most important information: I’m...

Read the latest Blogs

Forums

Dropping a Logon Trigger

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Dropping a Logon Trigger

SQL Injection Is Not Acceptable

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Injection Is Not Acceptable

Unzipping Word Documents in T-SQL

By cmartel 20772

Comments posted to this topic are about the item Unzipping Word Documents in T-SQL

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