Technical Article

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)

You rated this post out of 5. Change rating

2005-03-14 (first published: )

3,896 reads

Technical Article

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)

You rated this post out of 5. Change rating

2002-04-08

3,036 reads

Blogs

T-SQL Tuesday #178–A Recent Technical Problem

By

This month we have a good invitation from Deepthi Goguri, where she asks us...

WordPress.com and Developers: Roadmap Update

By

Where we've been and where we're going.

Redgate Clone Graduating Images

By

I wanted my own custom image in our internal Redgate Clone cluster, so I...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

By muhkam

Comments posted to this topic are about the item How to Add a New...

Setting Emergency State

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Setting Emergency State

Visit the forum

Question of the Day

Setting Emergency State

Which server role(s) can set a database to the Emergency State?

See possible answers