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

Daily Coping 30 Mar 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Error handling protip: @@Error resets after the next command

By

The system variable @@ERROR is a quick and easy way to retrieve the error...

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

By

Introduction Recently have been working on a “Proof of Concept” task where I wanted...

Read the latest Blogs

Forums

The Coping Thread

By Steve Jones - SSC Editor

I've started a series on my blog about coping strategies during the pandemic: https://voiceofthedba.com/tag/life/...

Get the difference from one record to the one previous

By Meridian9300

In it's simplest form I want a table that I can use to store...

Regarding for Microsoft Azure Certification

By Ankitdixit

Hello Everyone, I am new here and I am preparing for microsoft azure certification...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers