Find Procedures and tables by column

The stored proc FindObjByColumn_sp, while simple, is extremely useful when making database changes or for any reason that you need to find any tables and stored procedures that contain a particular column.  It searches the system tables of a database to find the object containing the column.  In addition, the procedure automatically adds a wildcard […]

2002-10-31

417 reads

Blogs

Goal Progress for July 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Data Modeling at your fingertips

By

(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...

How to put a SQL Server Database into Recovery Pending

By

You might be asking why on earth would you want to get a database...

Read the latest Blogs

Forums

How is Throughput optimized HDD (st 1)

By kratosrules99

Hi Everyone. i am planning to shift my website to AWS   I want...

Alternative to LAG(SUM) - Can a Column Reference The Sum of the Values Above It

By John O'Connor

Hi Everyone, I'm trying to do something that seems pretty simple, but SQL Server...

Transaction log shrink w/ logshipping

By mavelzen

Hello everyone, Again with this question. 🙂 I've got a log-shipped database, and I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers