Re: Oracle NULL vs '' revisited

From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Wed, 22 Aug 2007 06:54:41 +0100
Message-ID: <fagj53$cj9$1$8300dec7@news.demon.co.uk>

I see you chose to ignore this one as well...

CREATE TRIGGER connection_limit_trigger
ON ALL SERVER WITH EXECUTE AS 'login_test' FOR LOGON
AS
BEGIN
IF ORIGINAL_LOGIN()= 'login_test' AND

    (SELECT COUNT(*) FROM sys.dm_exec_sessions

            WHERE is_user_process = 1 AND
                original_login_name = 'login_test') > 3

    ROLLBACK;
END; We use CREATE TRIGGER, there are hundreds of events that are captured using the CREATE TRIGGER, LOGON is just one of many 'system' level events.

I'll make it easy, here is the reference now update your biased rubbish: http://msdn2.microsoft.com/en-us/library/ms189799.aspx

The fact you don't want to says it all,

-- 
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson


[Ramblings from the field from a SQL consultant]

http://sqlserverfaq.com


[UK SQL User Community] 

Received on Wed Aug 22 2007 - 00:54:41 CDT