Two quick queries on syscomments to find every stored procedure related to table names you search for, since sp_help and sp_depends are not always accurate.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Cursor to Kill All Process in Database
A simple cursor to kill all process connections in one database. It reads sp_who into a temp table and runs KILL for each spid. Run it from another database.
SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created
A simple cursor to select tables in a database by a static prefix like b_ or delete_ and by date created, so you can drop, print or index old tables.
SQL SERVER – Auto Generate Script to Delete Deprecated Fields in Current Database
I mark old columns with a dep_ prefix, then auto generate the script to delete deprecated fields and drop their constraints first. Here is the query I use.
SQL SERVER – Query to Find ByteSize of All the Tables in Database
A short query to find the ByteSize of All the Tables in a database. It sums column lengths per table from sysobjects and syscolumns, with a WITH CUBE total.
SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database
A long query on INFORMATION_SCHEMA views that shows foreign key relationships for each table: the table, column, referenced table and the constraint name.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.