Andrew Bancroft • 1/9/2018

Search Database Object Definitions for Text

Read Original

This article provides SQL scripts to search for specific text within the definitions of database objects such as scalar and table-valued functions, stored procedures, triggers, and views. It includes two alternative T-SQL queries using sys.sql_modules and SYSCOMMENTS tables, allowing users to find occurrences of a given string in object definitions. The content is a technical guide for database developers and administrators.

0 comments
#database #sql #Stored Procedures
Search Database Object Definitions for Text

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
Limit token usage in Microsoft Agent Framework
Jesse Liberty • 1 votes
2
How to Roll Back AI Agents: Incident Response, Circuit Breakers, and Recovery Patterns
Paul Bryant • 1 votes
3
Avoiding Reasoning Model Failures with Microsoft Foundry
Luke Murray • 1 votes
4
When Your AI Agent Lies: Silent LLM Fallbacks
Luke Murray • 1 votes
5
Adding a custom MCP server to Claude and ChatGPT
Simon Willison • 1 votes
6
Testing AI prompts and comparing models with promptfoo
Tim Deschryver • 1 votes
7
Superlogical
Mitchell Hashimoto • 1 votes