Viewing and Modifying Login Information
Perform the following steps to view login information:
1. |
From the SQL Server Enterprise Manager, click the plus (+) sign next to the server that contains the login.
|
2. |
Click the plus (+) sign next to the Security folder.
|
3. |
Left-click the Logins icon. A list of logins appears in the Result pane.
|
4. |
Right-click the name in the Result pane. From the right-mouse menu, select the Properties menu option. The SQL Server Login Properties dialog box appears. From this dialog box, you can view and modify login information.
|
The corresponding Transact-SQL commands to view login information are as follows:
sp_helplogins [[@LoginNamePattern =] 'login'] sp_helprotect [[@name =] 'object_statement'] [,[@username ...Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
