Find Orphan Logins in SQL Server2000

Hi,exec sp_change_users_login 'report' displays the list of orphan USERS in a database but we don't have any builtin SP which displays the orphan LOGINS.By Orphan Logins (not users), I mean the Logins that don't have any access to any databases and are sitting idle on the server (also aren't member of any fixed server role).We […]

5 (1)

2007-06-21

257 reads

Blogs

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Buy Dumps , Dumps With Pin Shop , Buy Dumps With Pin Online Fast And Easy 2021

By mikenco52

Visit my Shop to Buy Dumps , Dumps With Pin , CVV2 , CCV...

LEGIT CVV DUMPS WITH PIN SHOP ONLINE 2021

By mikenco52

SHOPDUMPS101.ONLINE Legit Dumps With Pin Shop Online 2021 - Buy Dumps With Pin Fresh...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers