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,661 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,029 reads

Blogs

Daily Coping 5 Mar 2021

By

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

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

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

Read the latest Blogs

Forums

Missing Integration Services Catalogs folder in SSMS

By giles.clapham

I've developed an SSIS Package that I need to deploy to a remote server,...

Distinguish Between Identical Rows

By Neil Burton

We're in the middle of a project to load IIS log files into a...

Snowflake ODBC to SQL Ole Destination ERROR

By darkangelBDF

Hi there, everyone. We've create and SSIS package that gets data from a Snowflake...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers