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 Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
This article takes us to the edge with a couple of CRM related errors...
I have Analysis Services cubes with over 200 dimensions in them (product requirement believe...
Hello, We are a small shop and want to run, for data warehousing/reporting, 2016...
Inherited about 190 2008 servers I need to migrate. Was going to build 2014/16...
Ask SSC