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

You rated this post out of 5. Change rating

2002-09-05

346 reads

Blogs

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

What I Love About My Job

By

In June this year I took redundancy from the company I’d worked at for...

TryHackMe Advent of Cyber

By

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...

Read the latest Blogs

Forums

STUFF Command Not Working

By AMCiti

I am trying to use the STUFF command, however, the column using the STUFF...

SQL Replication - Disconnected from Azure Storage with OS result code: 0

By DanielP

Hello, We had a few errors with replication for SQL Managed Instance stopped working...

Provider not found in SSMS

By cphite

I am trying to setup a linked server and per the documentation it needs...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers