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,600 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,267 reads
2008-06-08
1,875 reads
Blogs
Query multiple Azure SQL Databases
I was sick of changing context in Azure Data Studio while cleaning up things...
KDA: Echoes of Deception - Case 3
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
The Book of Redgate: Do Your Best Work
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Forums
Helpful Management Studio Settings and Features
Comments posted to this topic are about the item Helpful Management Studio Settings and...
The Minimal Linked Server
Comments posted to this topic are about the item The Minimal Linked Server
The AI View From Above
Comments posted to this topic are about the item The AI View From Above
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers