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
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Comments posted to this topic are about the item Numeric and Decimal, which is...
insert into dbo.details ( DetailId ,DetailName ) select distinct st.stdid ,st.name from dbo.student st...
i am struggling with a query to avoid while loop, please guide me if...
Ask SSC