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'

2006-02-02 (first published: )

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

2004-04-06

592 reads

Blogs

How To Start And Run A Great Home Business

By

With the current state of the economy, many people are seeking out opportunity in...

Proven Strategies For Your Home Business

By

A home business is a popular choice for many people. But it can also...

Get Educated About Home Business With These Simple To Follow Tips

By

Operating a home business can be both exciting and frustrating, with several things that...

Read the latest Blogs

Forums

how to identify BottleNeck by using the data of sys.dm_os_performance_counters

By 892717952

There are many many data to show the SQL Server current performance, May I...

SQL Query Help on Time based query

By dcw8888

I have a following table (Contains script to generate the sample table with data):...

When to Use a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When to Use a Database

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers