Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Client login user

Author  Topic 

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-03-26 : 05:46:09
hi,
select SYSTEM_USER as UID ,a,b from tab.
using this command we will find out server user id.
But how i can find out client User id using sql command.

My objevtive :
I want to fillter data depends on client login.

Regards,
avijit

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-03-26 : 05:58:56
Is this what you're after?

SELECT user_id(), user_name()

There are 10 types of people in the world, those that understand binary, and those that don't.
Go to Top of Page
   

- Advertisement -