Deepthi Viswanathan Nair


Generate Stored Procedure/Functions Script with SP

It will help to generate DBscript of Stored Procedure/User defined Functions in SQL server without selecting those thru Enterprise manager.Pass the name of Stored procedures/Functions as parameters to the sp_Generate_Script, it generates the scripts and displayed on screen. Choose text format for result display.

3 (5)

2007-03-23 (first published: )

2,072 reads

Blogs

Book Review: Lights Out

By

I have always been interested in GE since I was a kid. My best...

A Successful Blogger on Making the Switch

By

For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...

Login Timeouts

By

I was recently approached at work about a company that was seeing tons of...

Read the latest Blogs

Forums

Oracle: ORA-01843: not a valid month

By CraigF

Hi I have the following query which works fine in Oracle SQL Developer. When...

SQL Server internal variable with DML type

By sergino.taglia

Can you advice how to retrieve the DML type a query is running? Does...

How to Convert Oracle SQL to T-SQL

By carlton 84646

Hello Community, I have been given a challenge of converting the following SQL code...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers