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

331 reads

Blogs

Extended Events Misperceptions: Profiler is Easier, Part 2

By

I wrote a short blog post about the misperception that Profiler was easier than...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

By

If you read the title to this post and your first thought was That’s...

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

By

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...

Read the latest Blogs

Forums

Database Integrity Check jobs running for ever in Sql 2012

By pdsqsql

We have Database Integrity Check jobs running every early morning during off hours into...

Auditing System questions- no personal experience

By Scjohnson243

Good Morning All -I have used triggers to do some basic auditing, but I...

Table Growth

By Nita Reddy

We have 30 K tables in DB and I have a table which checks...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers