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: 2006-01-18)
90 reads
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
By Kamil
Another week passed. Look what did I find during that time. Press British Airways...
By HamishWatson
This blog post is around the changing landscape of both SQL Server and the...
By Arun Sirpal
Quite a simple requirement (when I needed it a few months ago). Study my...
Hi all, i am stuck trying to group 2 lines into 1. Hope someone...
Hi dears, I will explain the case: I have an MS Access Database on...
Hi all, i am stuck trying to group 2 lines into 1. Hope someone...
Ask SSC