Technical Article

Another Script to Dump DTS packages to Text

This script will dump most of the structure of a DTS package to a text file. This includes connections strings (note SQL Server connections have their passwords encrypted so the won't dump), tasks, steps, global veriables, etc.) The script is command line drive and should allow for the use of trusted or SQL logins. I […]

You rated this post out of 5. Change rating

2006-02-07 (first published: )

373 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

increase in database size

By vsamantha35

Hi All, We have a 2 TB disk to stored of the sql database...

indexes cleanup

By vsamantha35

Hi All, Recently we are having issues with disk space requirements. After monitoring db...

Dropping a Logon Trigger

By Steve Jones - SSC Editor

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

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