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,331 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,211 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,663 reads
2008-08-08 (first published: 2008-06-16)
919 reads
2008-08-06 (first published: 2008-06-16)
2,307 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,620 reads
2008-07-29 (first published: 2008-06-08)
1,255 reads
2008-06-08
1,861 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
Drop or delete a existing partition
Hello, so I was reading on partitioning a large table, Which i successfully did,...
PostgreSQL authenticated against Microsoft Active Directory
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
Ask SSC