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,298 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)
4,975 reads
2008-08-08 (first published: 2008-06-16)
910 reads
2008-08-06 (first published: 2008-06-16)
1,320 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,613 reads
2008-07-29 (first published: 2008-06-08)
1,230 reads
get users across all databases on the SQL Server instance
Quick way to get all users on all Databases
2008-07-24 (first published: 2008-06-06)
1,650 reads
2008-06-08
1,811 reads
Blogs
Last Weeks Reading (2019-05-26)
By KamilN78
It was tremendously extensive week for me (a week ago) when I spent time...
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Proverbial Tree Barking
Hi All, I'm just after a pointer really. I've had an idea. I want...
Transforming rows into columns
Hi Everyone, I have a table with the structure as attached in the Table...
Ask SSC