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

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

CRM Data Source Connection Error

By

This article takes us to the edge with a couple of CRM related errors...

Read the latest Blogs

Forums

Detereming Trends in SSAS Cube

By Freefall99

I have Analysis Services cubes with over 200 dimensions in them (product requirement believe...

SSDT server setup and using 3rd party tools across servers

By dmusson17

Hello, We are a small shop and want to run, for data warehousing/reporting, 2016...

Migration sandbox

By tcroninlifepoint

Inherited about 190 2008 servers I need to migrate.  Was going to build 2014/16...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers