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,315 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,069 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,658 reads
2008-08-08 (first published: 2008-06-16)
918 reads
2008-08-06 (first published: 2008-06-16)
1,979 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,618 reads
2008-07-29 (first published: 2008-06-08)
1,250 reads
2008-06-08
1,824 reads
Blogs
A Few Thoughts on SQL Saturday Jacksonville
By Steve Jones
I was lucky to attend SQSQL Saturday Jacksonville 2022L Saturday Jacksonville 2022 a couple...
Techorama 2022 – Session Materials
You can find my slidedeck for the session “Introduction to Azure Data Factory” on...
Daily Coping 24 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Logging sql stms into a table when there is a High cpu alert
Hi, Whenever I get an high cpu alert , be it non-working hours or...
Transactions names meaning In Transaction Logs
I am using .LDF file to get the information about when was DB last...
Ask SSC