How can I see the default database for login?

Question

I need to define a default database for login. What system table / view should I query for SQL Server 2005?

+6

tsql sql-server-2005

Vitali climenco Apr 2 '10 at 5:32

source share

2 answers

Piotr rodak · Answer 1 · 2010-04-05T21:44:10+0000

The view master.sys.syslogins is provided for backward compatibility and will be removed in the future . You must use sys.server_principals and the column name default_database_name.

Jeremydwill · Answer 2 · 2010-04-02T05:50:41+0000

You can get this information for a specific login using sp_helplogins.