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 […]
2007-06-21
266 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
I have data that contains poll results, with the poll_id consistuting a single row...
Hi everyone. I am re-writing a portion of my SSIS logic. My SSIS package...
Comments posted to this topic are about the item How are statistics stored?
How are the statistics for query optimization stored in SQL Server?
See possible answers