Is there any trigger on login.

We have this new request. on login, thro any application, we need to pass on
a sql server message to the application that the password will expire in so
x days. (There is a separate table to maintain the password history).

thanks a lot for the help. (thanks to SOX!)

No -- SQLS authentication occurs before authorization to any
particular database, and triggers are a feature of database tables.
However, you could code your application to inspect your password
history table for an expiration date on startup. Bear in mind that
this is less secure than using integrated security with Windows
logins, where you *can* set password expiration policy.

--Mary

On Tue, 17 Aug 2004 15:31:06 -0500, "Sat" <satheesh (AT) earthlink (DOT) net>
wrote:

select distinct spid, login_time, loginame
from master.dbo.sysprocesses
order by login_time desc


Per above, it seems that all logins to MS-SQL are recorded
in the [sysprocesses] table in 'master'. You "could" I
suppose put a trigger on this table to look for logins
that match the syntax you are looking for (either NTLM-
type or SQL authentication).

If the trigger was lightweight enough it shouldn't hurt
anything. What do you think?

-DMllp/DBA

You cannot put triggers on system tables.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


<anonymous (AT) discussions (DOT) microsoft.com> wrote