Phil Factor

  • Interests: Motorbikes, Beer, gardening, conservation, Local history.

External Article

What’s in that database? Getting information about routines

There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.

2020-03-17

Blogs

SQLServerCarpenter Tools

By

Over the past couple of years, I’ve developed several tools that I’ve been using...

usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

By

/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...

A New MVP Led Training Initiative – Cloud Formations

By

Hello Readers – I wanted to make sure those who follow my blog have...

Read the latest Blogs

Forums

SQL Server 2014 Question

By kazana

So I have inherited an older SQL 2014 Server and have been working on...

Removing UNION and getting the same result

By azdeji

Hi, I need to update my sql script and remove the UNION but get...

SQL Server 2019 HA

By celigo

Looking for a HA solution for SQL server for our branch offices. Current setup...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers