So you want to fetch the unique identifier for the user that's running the report? This relies on users running the report using their own Windows credentials. You need Kerberos in place for that, otherwise you'll fall victim to the double-hop issue[/url].DECLARE @DBUID int

SELECT @DBUID = [database unique identifier for the user]

FROM MyTable

WHERE [domainname&username] = SUSER_NAME()

John