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

254 reads

Blogs

Trace Query in Extended Events

By

The ability to quickly and easily trace a query is important to database professionals....

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Read the latest Blogs

Forums

How to import Excel with XML

By itmasterw 60042

Hi, I have an Excel sheet that I have to import into SQL Server....

Recursive CTE - Batches

By koti.raavi

Hi Folks I'm trying to group rows into batch and adding batch to query...

XQuery - Use column value to display correct node

By Norty303

Hi All First time with XQuery and despite trying to read as many guides...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers