Home

	Expand Search

Transact-SQL User's Guide

Chapter 1 SQL Building Blocks

Adaptive Server login accounts

Getting information about your Adaptive Server account

Getting information about your Adaptive Server account

You can get information about your own Adaptive Server login account by using:

sp_displaylogin

Adaptive Server returns the following information:

• Your server user ID

• Your login name

• Your full name

• Any roles granted to you (regardless of whether they are currently active)

• Whether your account is locked

• The date you last changed your password