13.select * from sysprocesses where loginame like '324%'----dipl

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

Question Posted / naren

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Can you please explain the difference between primary keys and foreign keys?

1110

What are the features of Embedded SQL

1129

What are the authentication modes in sql server? How can it be changed?

1130

How to create new tables with "create table" statements in ms sql server?

1066

What are the properties of primary key?

974

Explain in brief how sql server enhances scalability of the database system?

981

How to create a local temporary stored procedure?

998

Mention the differences between local and global temporary tables.

1043

When multiple after triggers are attached to sql table, how to control the order of execution?

1049

Can I run multiple instances of sql server 2000 at the same time on one computer?

1074

What is data source in connection string?

907

How to concatenate two binary strings together?

1125

What is 2nf in normalization?

997

How to add an address record into adventureworkslt?

986

Do you know what are pages and extents? : SQL Server Architecture

995