Update statistics in all database (sp_updatestats)

This script permit executes the sp_updatestats in all databases at same time.First I create the stored procedure above in an admin database, for sample I create one database with ADMIN name where I put all administration objects create for me. You can create this sp in exist db, if you want.Now you can execute this […]

4.5 (2)

2005-04-14 (first published: )

4,039 reads

Blogs

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

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

ADF: Querying JSON documents

By

In my previous blog post I talked about how to read from an XML...

Read the latest Blogs

Forums

Distributed AG DB movement

By Syed_SQLDBA

I have a DAG between On prem and Azure. We have a maintenance window...

object_name (st.objectid) returns NULL. How can I overcome/fix this?

By VoldemarG

How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...

List all stored procedures which return datasets

By AlexF

Is there any way to do that? I need to list that kind of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers