• SQL Server doesn't track those things. Therefore, no, there is no T-SQL command capable of getting that information.

    However, you could use PowerShell or xp_cmdshell to get out to a command prompt and then query for that information using the usual methods.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.