Re: Login Triggers?



No, sorry.

If you want to track logins, you can log all login attempts. Or you can run
a SQL Trace that captures that information. However, if you wanted to do
some additional work for the user, there is no trigger for that.

RLF
"Joe D" <jkdriscoll@xxxxxx> wrote in message
news:dvph8d$2k91$1@xxxxxxxxxxxxxxxxx
Quick question about SQL 2000. Are there ways to have a trigger fire when
someone (anyone) logs in to a MSSQL SQL 2000 instance? I had thought MSSQL
came with login triggers but I haven't been able to find any info.

TIA,
JD



.