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
When studying Azure one of the things you’ll be asked to learn is the...
I’ve written about statistics in SQL Server a few times now. Through conversations I...
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...
Comments posted to this topic are about the item Is Data the Future of...
Comments posted to this topic are about the item Stairway to SQLCLR Level 2:...
Good Morning, We had an issue yesterday where SQL Alerts were generated from one...
Ask SSC