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,972 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,041 reads

Blogs

The Book of Redgate–Being Reasonable

By

As a part of the Book of Redgate, we have a series of (red,...

Azure Data Factory Pipeline Debugging Fails with BadRequest

By

I recently had a new pipeline fail. It was actually a copy of an...

Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric

By

Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...

Read the latest Blogs

Forums

Count of Distinct Values

By jagjitsingh

Hi If value is 21000030 it should return 4 not 5 . In first...

Joining against min date only

By darrell.woolaver 91826

This is one of those things very hard (for me)to explain in words. See...

Feeling your age? How would you know?

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Feeling your age? How would...

Visit the forum

Question of the Day

Rolling Back CUs

Can I rollback a cumulative update and remove it from my SQL Server instance?

See possible answers