Home
Blogs
Forums
Downloads
Site Search:
Sign in
|
Join
|
Help
This Blog
Home
Contact
Common Tasks
Syndication
RSS
Atom
Comments RSS
Receive Email Updates
Subscribe
Recent Posts
for XML PATH
Combined INSERT, UPDATE and SELECT statements
Create an update statement
Cursor Template
Grant permissions cursor
Tags
aggragate
comma
mail
Recovery Model
semicolon
sp_OACreate
sp_OAMethod
SQL 2000
SQL 2005
sql mail
sql server
sqlmag.com
streamwriter
syscolumns sysobjects
sysobjects
text file
truncate log
Archives
August 2008
(3)
July 2008
(1)
June 2008
(1)
May 2008
(2)
April 2008
(1)
January 2008
(3)
December 2007
(5)
November 2007
(3)
October 2007
(3)
August 2007
(7)
June 2007
(1)
May 2007
(1)
April 2007
(2)
March 2007
(5)
February 2007
(3)
January 2007
(9)
SQL Server (T-SQL)
Comments and notes on SQL Server 2000, 2005, and T-SQL
Browse by Tags
All Tags
»
sp_OAMethod
»
sp_OACreate
(
RSS
)
sysobjects
text file
Send the Contents of all the Stored Procedures, Triggers, and Functions to a Text File
This script will send the contents of all the Stored Procedures, Functions, and Triggers in a database to a text file. In fact, it will send any object that can be found in SELECT * FROM SYSOBJECTS Why is that useful? For me, it's indispensible. The...
Posted
Mar 24 2007, 04:39 PM
by
Steve Gray
with | with
1 comment(s)
Select Tags...
Save
Cancel
Filed under:
sp_OAMethod
,
sp_OACreate
,
sysobjects
,
text file
[Edit Tags]