adspace


What is the security principal at the server level that represents your session?

Answer Posted / Munesh Singh

The security principal at the server level that represents your SQL Server session is called the 'current user'. The current user owns all objects created during the session by default. You can find out who the current user is using the `SELECT SUSER_NAME()` function.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can sql servers link to other servers like oracle?

919


How to convert numeric expression data types using the cast() function?

1151


What is the primary use of the model database?

1151


What are the source of constraints?

1010


What is temporary table in sql server? Why we use temp table?

1023


What are the different SQL Server Versions you have worked on?

1080


How to remove duplicate rows from table except one?

1090


Does view occupy space?

1021


How can we solve concurrency problems?

1123


Why use identity in sql server?

1202


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1024


What are wait types?

1250


What is normalization and what are the advantages of it?

1057


Can we shrink data file in sql server?

1130


Explain system functions or built-in functions? What are different types of system functions?

1067