Technical Article

sp_SearchObjectsAllDBs

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'

You rated this post out of 5. Change rating

2006-02-02 (first published: )

94 reads

Technical Article

Write Text File

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 '*').

You rated this post out of 5. Change rating

2004-04-06

597 reads

Blogs

Code signing for mere mortals

By

Well, turns out code signing is pretty complex, so I’m writing this blog post...

Blogging for the Tech Professional at Denver Dev Days

By

For those that attended my talk at Denver Dev Days, here are the slides:...

Getting AI Written Unit Tests

By

As a part of my AI experiments, I decided to ask CoPilot to write...

Read the latest Blogs

Forums

Software Flexibility (Avoiding the next hack)

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Software Flexibility (Avoiding the next...

Roles on tempdb

By cphite

A co-worker asked me a question today and I couldn't come up with an...

Delayed tcp acknowledgement registry setting

By Rasmus Remmer Bielidt

Our IT department contacted me recently and asked if they should change the default...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers