Logins enabled

Question

Post reply

Logins enabled

mahesh.dasoni

SSCommitted

Points: 1653
More actions
September 17, 2012 at 1:14 am

#262013

Query to find out list of logins that are enabled in SQL SERVER 2005.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113509 More actions · Answer 1

Ant-Green

SSC Guru

Points: 113509

September 17, 2012 at 2:03 am

#1538432

Query sys.server_principles

alfgomled SSC Journeyman Points: 77 More actions · Answer 2

use model

select * from sys.server_principals

and not principles

OK ??

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 3

use model

Model ?? You should be able to execute from any DB including Model, as system views are automatically inserted in all the databases including users DBs..