Check Login stored proc in sql server

1

How to create check login proc in sql server.
plz advice me

2

maybe

select SYSTEM_USER

3

Goodmorning sir
I am new in sql server. plz provides details...

4

Do you want to audit a particular login?

5

Yes sir...

6

you can use the builtin audit feature under security in SQL Server management studio.

7

check login for e-comm project in sql server

8

You have to understand that we have no idea what you want for any of this.

Are you asking for how to check a login for which databases it has access to a what privs it has for each database and at the server level?

Or, are you asking if a login for a particular application simply exists and that they've used a correct password to login?

Or something else?

9

login for a particular application simply exists and that they've used a correct password to login?

10

If you want to create a login procedure. This may help you: [Solved] stored procedure for login - CodeProject