Skip to main content

SQL Server: How to find related db objects (views, stored procedure) for a table; Search stored procedures


The following code will help to find all the Stored Procedures (SP), Views, User defined functions which are related to one or more specific tables.  This is very useful since sp_help and sp_depends does not always return accurate results.
SELECT DISTINCT SO.NAME, SO.XTYPE
FROM syscomments SC
INNER JOIN sysobjects SO ON SC.ID=SO.ID
WHERE SC.TEXT LIKE '%tablename%'
Labels:
Location: Chennai, Tamil Nadu, India

Comments

Post a Comment

Popular posts from this blog

AI Evaluation Harness: From Prompt Tests to Production Release Gates

A practical framework for building an AI evaluation harness that links test quality to release decisions and operational confidence. Evaluation harnesses turn subjective model quality into measurable release criteria. Combine functional, safety, latency, and cost checks into one pipeline. Block releases when critical thresholds are missed, even under delivery pressure. If your AI release decision is based on a demo, you are not releasing engineering software; you are releasing a hope strategy. A proper evaluation harness creates repeatable evidence for quality, safety, and cost trade-offs. Prerequisites Versioned prompts and model configuration. Representative test dataset by use case. CI/CD pipeline with artefact retention. Clear service-level objectives for latency and reliability. Evaluation layers 1) Functional correctness Golden set response checks. Tool invocation correctness. Schema compliance for structured outputs. 2) Safety and policy Prompt in...
Post a Comment
Read more

AI Security and Ethics Checklist for Engineering Teams

A practical pre-release checklist for AI features covering security, misuse risk, transparency, and governance. Shipping AI features without security and ethics checks creates hidden operational risk. Use this checklist before each release. 1) Data and privacy Confirm data minimisation in prompts and context. Remove secrets and personal data from logs. Enforce retention windows for model inputs and outputs. Validate third-party processor boundaries. 2) Security controls Restrict tool permissions by role and environment. Validate all tool outputs against strict schemas. Add prompt-injection defences for external content. Require approval gates for high-impact actions. 3) Safety and misuse Define clear disallowed use cases. Add risk prompts for potentially harmful requests. Add user-visible warnings for uncertain outputs. Add abuse monitoring and escalation paths. 4) Transparency and trust Disclose where AI assistance is used. Explain known limitations...
Post a Comment
Read more

Scaling AI Agents in Insurance Claims: Human-Centric Automation Strategies

Design patterns for agent-assisted claims that amplify human judgment while achieving 40% faster processing in regulated settings. Design patterns for agent-assisted claims that amplify human judgment while achieving 40% faster processing in regulated settings. 2026 insurance predictions stress hyper-automated claims with people-first AI. Includes controls, pitfalls, and a phased implementation path. Design patterns for agent-assisted claims that amplify human judgment while achieving 40% faster processing in regulated settings. Why this matters Teams are under pressure to deliver AI capability quickly, but speed without control creates operational and governance risk. This guide focuses on practical execution patterns that hold up in production. Prerequisites Clear ownership for delivery and risk decisions. Baseline observability for model and tool behaviour. Defined quality and security acceptance criteria. Practical approach Define the business decision this...
Post a Comment
Read more