hi

i'm being asked to log, users workgroup_name and domain_name in an
audit trail? is this do-able?

how shud i proceed on this?

thanx

If you are using Windows authentication on your SQL server, you could use

SELECT LEFT(SYSTEM_USER, CHARINDEX('\',SYSTEM_USER) - 1)

to get the domain name of the user that is connecting. If a user is
connecting from a workgroup system, the above will get the name of their
machine instead of the workgroup name.

Show quoteHide quote

Select where result are by the best match
where current of cursorName
Really really slow cursor
Problem copying data from column in same table
reverse like?