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,300 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,979 reads
2008-08-08 (first published: 2008-06-16)
911 reads
2008-08-06 (first published: 2008-06-16)
1,454 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,231 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,812 reads
Blogs
Cursor Dynamic SQL
By Vinay Thakur
Today was working on SQL Server cursor standard cursor deification would be like this:...
How to get the Active Directory user password policy values
By SQLPals
Recently I have had to troubleshoot quite a bit of SQL login issues and...
How do you use PowerShell toc check if an active directory user locked out, disabled etc.?
By SQLPals
If your organization uses a password policy (there are very good odds these days...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
How does DBCC CHECKDB use tempdb?
I would like to know the working principle of DBCC regarding the tempdb. I...
Ask SSC