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

342 reads

Blogs

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

SharePoint List only returns 100 items in Azure Logic App

By

I was reading a SharePoint List using the “Get Items” activity in an Azure...

Daily Coping 27 Jun 2022

By

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

Read the latest Blogs

Forums

Database backup and restore

By DBA

Hello, I've a user database which I want to migrate to new server, so...

Help Implementing Sample SQL Code

By carlton 84646

Hi community, I am trying to implement sample sql code: SELECT [LocalizedLabel] as [<COLUMN_NAME>]...

Error restore database in AZURE

By abdalah.mehdoini

Hello everyone, I created my SQL server Azure in PASS when i try to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers