How to create check login proc in sql server.
plz advice me
maybe
select SYSTEM_USER
Goodmorning sir
I am new in sql server. plz provides details...
Do you want to audit a particular login?
Yes sir...
you can use the builtin audit feature under security in SQL Server management studio.
check login for e-comm project in sql server
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?
login for a particular application simply exists and that they've used a correct password to login?
If you want to create a login procedure. This may help you: [Solved] stored procedure for login - CodeProject