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,308 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,022 reads
2008-08-08 (first published: 2008-06-16)
918 reads
2008-08-06 (first published: 2008-06-16)
1,868 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,248 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,657 reads
2008-06-08
1,818 reads
Blogs
Book Review: Lights Out
By Steve Jones
I have always been interested in GE since I was a kid. My best...
A Successful Blogger on Making the Switch
By todd-32417
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...
Login Timeouts
I was recently approached at work about a company that was seeing tons of...
Forums
Oracle: ORA-01843: not a valid month
Hi I have the following query which works fine in Oracle SQL Developer. When...
SQL Server internal variable with DML type
Can you advice how to retrieve the DML type a query is running? Does...
How to Convert Oracle SQL to T-SQL
Hello Community, I have been given a challenge of converting the following SQL code...
Ask SSC