Recompile all Udf's associated with a Table

When altering the structure of tables it is good practice to run SP_RECOMPILE against the table to force triggers and stored procedures to recompile. However this does not incude Udf's which also rely on the table, and this means the Udf's may fail when they are called. Run this script and supply the table name […]

2002-09-05

335 reads

Blogs

Logging Messages with Raiserror – #SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 8 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Webinar – Building a Proper SQL Server Database Security Model

By

Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...

Read the latest Blogs

Forums

Importing text file issue

By smattiko83

Hi, I am trying to import the attached REF_RF1MAS.txt file but am getting numerous...

Empty Index Statistics object

By AnzioBake

This is a new thread but relates directly to Index statistic is empty -...

Transactions

By sizal0234

Hi, Can you please let me know what is the benefit of using the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers