Is there away to determine the last time the guest account was used on a SQL
Server 2005 database server?

Thanks,

No unless you have already set up some kind of audit trace.

Linchi

"Joe K." wrote:

Joe
Try create a LOG ON ddl trigger , you can change the logic behind to
INSERT the data into a table or DENY ACCESS to the login i

Create login AuditLogin with password = ‘AuditLoginPswd’
go
/*Create a very simple login trigger */
create trigger AuditLogin_Demo
/* server means instance level*/
on all server
with execute as self
/* We specify the logon event at this stage
– If there are more than one connections,
– Issue a rollback*/
for logon
as begin
IF ORIGINAL_LOGIN()= ‘AuditLogin’ AND
(SELECT COUNT(*) FROM sys.dm_exec_sessions
WHERE is_user_process = 1 AND
original_login_name = ‘AuditLogin’) > 1
ROLLBACK;

end
go

"Joe K." <JoeK (AT) discussions (DOT) microsoft.com> wrote

Joe K. (JoeK (AT) discussions (DOT) microsoft.com) writes:
Unless you have created a login called "guest", there is any such account.

In all databases there is a *user* guest, which is used under some
cicrumstances that I don't remember on the top of my head now. But I
think it has to do when you access a database from another database in
which you do not have a user mapped to your login, but the access is
still valid due to ownership chaining. As far as I know, you cannot
track that.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx