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)
94 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
596 reads
Last month (I ran just a little bit late writing this, it was meant...
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
Hi All, I have a requirement that if there is no weekend data then...
Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...
Comments posted to this topic are about the item How Important is Software?
Ask SSC