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,795 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,033 reads

Blogs

Derby City Data Days

By

It was awesome to see the Kentucky data community come out for the first...

Tomorrow: Webcast on SQL Server security

By

Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...

A New Word: the Wends

By

the wends– n. the frustration that you’re not enjoying an experience as much as...

Read the latest Blogs

Forums

Should I create tables with dynamic SQL?

By mjdemaris

Hello all, I am thinking of creating a "shopping cart" in our application.  My...

Expression Error ( property 'Error' cannot be selected )

By rjdineen

Hello there. I have the following Pipeline I want to get the property error...

create cluster fails Win2016.

By snomadj

I'm installing a cluster prior to my 2019 SQL build.   Failover Cluster tools...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers