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,068 reads


SQL Server Containers Are Boring


Not really, but sort of. The beauty of containers, at least in a dev/test...

Public Role Permissions – Back to Basics


If you are being serious in your role, then the amount of times you...

It’s interesting how an OR short circuits.


I recently did a post on the case expression short circuting and received a...

Read the latest Blogs


Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Report copy of 2008R2 on 2017

By paul.doherty

Hi all ,   we have a proprietry 2008R2 Standard OLTP db which is...

Using variables in Lookup transformation

By pwalter83

Hi, I have a requirement to use variables in a lookup transformation, does anyone...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers