USER_ID(). other system functions like USER_NAME(), SYSTEM

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

Question Posted / swapna

Answer Posted / swapna

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

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is difference between delete & truncate commands?

1083

Explain what is the difference between a local and a global temporary table?

1003

How to find table changes in sql server?

1119

What is the default port for SQL Server over a firewall?

1097

What are transactions and its controls?

1061

What are the types of lock supported by ?

1044

Do you know what is rank function?

1073

Explain how many types of relationship?

1029

What are cascading parameters in ssrs reports?

230

how to create a scrollable cursor with the scroll option? : Sql server database administration

1091

What is default port number for sql server 2000?

1046

What different steps will a sql server developer take to secure sql server?

994

What is difference between clustered index and non clustered index?

1077

What is database black box testing?

1033

Do you know what are the reporting services components?

974