which system stored procedure is exicuting

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

which system stored procedure is exicuting

Author

Topic

boreddy
Posting Yak Master

172 Posts

Posted - 2009-03-11 : 01:55:57

I created the new user and password
when I tried to ligin whith the new user and password
which system storedprocedure is checking the user and password in databse

plese help me

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-11 : 02:29:58

Stored procedure? You are checking the login information against the SQL Server catalog tables. You can see if your login is failing or working by running trace on SQL Server and looking at Security: Audit Login, Security: Audit Logout, and Security: Audit Failed Login.

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources