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

Blogs

Cursor Dynamic SQL

By

Today was working on SQL Server cursor standard cursor deification would be like this:...

How to get the Active Directory user password policy values

By

Recently I have had to troubleshoot quite a bit of SQL login issues and...

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

By

If your organization uses a password policy (there are very good odds these days...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

How does DBCC CHECKDB use tempdb?

By RaufDBA

I would like to know the working principle of DBCC regarding the tempdb. I...

Minimum memory

By WhiteLotus

Hi All , Should we adjust the minimum memory per query (in KB)  in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers