Logins created in the last X Days
These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.
2011-12-23 (first published: 2008-06-08)
2,341 reads
Mani Singh
Search for a String in all Stored Procedures and beyond?
Search for String Occurence with this script in your stored procedures.
2011-10-20 (first published: 2008-06-08)
5,379 reads
get users across all databases on the SQL Server instance
Quick way to get all users on all Databases
2009-08-05 (first published: 2008-06-06)
1,675 reads
2008-08-08 (first published: 2008-06-16)
926 reads
2008-08-06 (first published: 2008-06-16)
2,672 reads
Grant Permission to Specific objects(e.g. SP's)
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,633 reads
2008-07-29 (first published: 2008-06-08)
1,280 reads
2008-06-08
1,884 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
Apply for a Gold Mandate License in Cameroon
Below you will find How to Apply for a Gold Mandate License in Cameroon...
Intermittent Service Freezes and "State 23" Authentication Failure
Environment: SQL Server: 2019 Enterprise (15.0.4430.1) OS: Windows Server 2022 Standard (Build 20348) Virtualization:...
SQL Server audit with windows ad group
I am trying to create a filter on a SQL Server audit to capture...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers