Hicks


Technical Article

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

345 reads

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Permissions Changes Not Doing Anything

By EsquireDeveloper

Hi friends, So I have a Login to a server that is a windows...

Re-creating AG after server loss

By izinger

We recently had to rebuild servers that were configured with AG. I built everything...

Cannot run DynamicSQL Statement to merge table with JSON

By Weegee71

Hi there I have a problem with a dynamicSQL Statement. In this code, I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers