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 KamilN78
It was tremendously extensive week for me (a week ago) when I spent time...
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Creating a custom container is where things get truly exciting. There’s actually a ton...
Comments posted to this topic are about the item The Change Failure Rate
Hi All, I'm just after a pointer really. I've had an idea. I want...
Hi Everyone, I have a table with the structure as attached in the Table...
Ask SSC