What is the system function to get the current user's user
id?

Answers were Sorted based on User's Feedback



What is the system function to get the current user's user id?..

Answer / swapna

USER_ID(). Also check out other system functions like
USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER,
SUSER_SID(), HOST_NAME().

Is This Answer Correct ?    6 Yes 0 No

What is the system function to get the current user's user id?..

Answer / hcl

select * from dbo.sysprocesses

Is This Answer Correct ?    0 Yes 0 No

What is the system function to get the current user's user id?..

Answer / naren

13.select * from sysprocesses
where loginame like '324%'----diply the all ohrid's in the
server

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,


Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  


What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  


What is acid mean in sql server?

0 Answers  






What is filtered index?

0 Answers  


What is nolock hint in sql server 2008

0 Answers   HCL,


what is sql server? : Sql server database administration

0 Answers  


How do I list the available tables in a database I'm querying?

4 Answers  


Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,


How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  


 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,


Categories