2013-12-19 (first published: 2007-08-27)
16,131 reads
Deepthi Viswanathan Nair
Dynamic creation of Insert, Update, Delete Stored procedures
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
2010-07-09 (first published: 2009-07-23)
33,160 reads
2008-09-09
1,051 reads
Get list of tables used in a stored procedure
It used to find the table dependencies, helps the developers during an enhancement stage to find the tables are used in a stored procedure.
2007-08-30 (first published: 2007-03-16)
3,113 reads
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.
2007-03-23 (first published: 2007-03-14)
2,069 reads
List of stored procedures which refer a DB table
It used to find stored procedures where a DB has been used.
2007-03-22 (first published: 2007-03-16)
448 reads
Blogs
Lock your Azure SQL Database
By Arun Sirpal
So you have many databases in Azure, you accidentally deleted one which can happen...
BlitzFileStats custom module available for Inspector V2
BlitzFileStats is the latest addition to our custom module collection for reporting on data...
Fun Fact: AWS RDS and system_health
Did you know that the system_health Extended Event session was running in your RDS...
Forums
Changing Connection Managers with the Configuration Manager
OK, this actually not a question, this is in response to a question I...
SSIS How to split a single string into multiple columns using Derived Column
Hello, In my source Column having comma separated with text qualifier(“), I would need...
Licensing Audit Advice
Comments posted to this topic are about the item Licensing Audit Advice
Ask SSC