Delete All Database User Accounts for a Given Server Login
Easily and quickly delete all database accounts even if they don't have the same name as server login.
2015-05-05 (first published: 2013-07-18)
4,640 reads
Find Stored Procedures and Functions That Reference Certain Tables
Find any code objects that interact with a given table/view, or call another given code object.
2015-04-10 (first published: 2013-07-05)
4,565 reads
Defrag All Indexes On a Database
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
2,602 reads
Blogs
Join SQLSat Memphis Virtually This Saturday
By Will Assaf
Looking forward to presenting at SQLSaturday Memphis virtually this weekend! Both my wife and I...
Failing SQL Agent Jobs – Part 4
By gbargsley
Here we are, another Tuesday!! It is time for our Fourth and final installment...
I Want PASS to Survive
By Steve Jones
I want PASS to survive. I can say that unequivocally, because this organization has...
Forums
trigger on a Large 5 billion row table
Hello, So we have noticed our trigger that does insert from one table to...
issue with adding another column in a table
Hi, i have a table named as Book_master_tbl having only 10 records and as...
When one of your DBA colleagues leaves the company, what is your checklist?
Comments posted to this topic are about the item When one of your DBA...
Ask SSC