Technical Article

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 […]

You rated this post out of 5. Change rating

2002-10-31

425 reads

Blogs

Enabling an Index: #SQLNewBlogger

By

I don’t do a lot of work with disabled index, but I learned how...

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

Read the latest Blogs

Forums

How are statistics stored?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How are statistics stored?

Where's the Printer Friendly Option?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Where's the Printer Friendly Option?

Switch from MSSQL SVC to MSA - Unable to start services

By sunilgk595@gmail.com

Using MSSQL 2019 standard edition It was installed using SVC Account. But now I...

Visit the forum

Question of the Day

How are statistics stored?

How are the statistics for query optimization stored in SQL Server?

See possible answers