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,333 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,361 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,669 reads
2008-08-08 (first published: 2008-06-16)
921 reads
2008-08-06 (first published: 2008-06-16)
2,585 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,626 reads
2008-07-29 (first published: 2008-06-08)
1,266 reads
2008-06-08
1,875 reads
Blogs
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I...
Forums
The Long Running Backup
Comments posted to this topic are about the item The Long Running Backup
Interview Tips
Comments posted to this topic are about the item Interview Tips
importing from PowerQuery... but with multiple powerqueries
I finally got the PowerQuery source to "show" in SSIS (so I can see...
Question of the Day
The Long Running Backup
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers