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,869 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,030 reads

Blogs

Daily Coping 24 Sept 2021

By

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

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

help with script to calculate gaps and overlaps from list of times

By chenks

hi got a question here that i hope someone can help with. i have...

Automatic INSERT-INTO

By LD3060

I have a view in my database where data is stored, it has 2...

Making Software Decisions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Making Software Decisions

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers