P_DBA (11/21/2008)
Hi,What is it you are exactly looking for ?
you cna use this to get a list of users:
SELECT * FROM sys.database_principals
WHERE TYPE='S'
THis query won't work unless you have 2005 or 2008.
In 2000 I don't know of a way to tell if or when a login was used. IN 2005 the default trace has that information.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question