sp_SearchObjectsAllDBs

Uses sp_ob by Saket Mittal to search all databases for objects of a like name. Examples: To search for a table named 'customer' : exec master..usp_SearchObjectsAllDBs @searchname = 'customer', @type = 'U' To search for a procedure named 'customer' : exec master..usp_SearchObjectsAllDBs @searchname = 'customer', @type = 'P'

2006-02-02 (first published: )

90 reads

Write Text File

Adapted from Rodrigo Acosta's script which exports to a text file the text of SPs.  Parameters are the table/view name (may include a WHERE clause) , the output file path/name, and an optional list of fields (may include user-defined functions,cast/convert,etc..., the default is '*').

2004-04-06

583 reads

Blogs

When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.

By

When studying Azure one of the things you’ll be asked to learn is the...

SQL Server Statistics Health Reminder

By

I’ve written about statistics in SQL Server a few times now. Through conversations  I...

Running SQL Server containers as non-root

By

Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

By Solomon Rutzky

Comments posted to this topic are about the item Stairway to SQLCLR Level 2:...

Database in Recovery Pending state

By bobba

Good Morning, We had an issue yesterday where SQL Alerts were generated from one...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers