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,301 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,982 reads
2008-08-08 (first published: 2008-06-16)
913 reads
2008-08-06 (first published: 2008-06-16)
1,565 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,234 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,653 reads
2008-06-08
1,813 reads
Blogs
Pluralsight Free April
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
Forums
Understanding and Improving Query Plans
Hi everyone. I have a process that is taking a long time to execute...
Daily Coping Tip 7 Apr 2020
Daily Coping Tip: Rediscover your favourite music that really lifts your spirits. My thoughts:...
Developer Edition
I am proposing to the business that we use SQL 2019 Developer in our...
Ask SSC