Stored Procedure Call Hierarchy

Easily extractss the complete stored procedure call hierarchy from "sysdepends" table of SQL Server and represent it in a pseudo-graphical tree-view.The script uses a temporary table (automatically created/dropped) to hold children and parents of relationships. For representing the call hierarchy the table contains a level field (depth) and a field containing the "enumerated path" (using […]

5 (5)

2005-03-14 (first published: )

2,286 reads

Database structure queries

Gets most important information of database structure. This includes all user tables, their fields, datatypes, defaults (including default constraint names), etc, primary keys and their fields, unique constraints and their fields, check constraints (including their conditions), foreign key constraints and their fields aswell as any other indexes and their fields. Should be quite useful for […]

5 (2)

2002-04-08

3,027 reads

Blogs

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Read the latest Blogs

Forums

Insert New Rows in sql based on difference between 2 dates

By PSB

Hi,   I want to create a new records based on the difference between...

COHESITY for Backup/Restore?

By daniel.dolan

Any one have any experience with using Cohesity as the backup/restore platform instead of...

View runs slower

By sathwik.em91

I have the following query SELECT DateADD(day,9-DATEPART(dw,cdata .call_datetime ),cast(cdata .call_datetime as date) ) as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers