2013-12-19 (first published: 2007-08-27)
16,814 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,506 reads
2008-09-09
1,052 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,114 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
Daily Coping 2 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Database Corruption, how to investigate root cause?
By nelsonaloor
Introduction: In this article, we will discuss the MS SQL Server database corruption. So, first, we...
Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?
I have held various certifications through my DBA career, from CompTIA A+ certification back...
Forums
SQL Server Load
Hi, The application team is pushing more than 7 lakhs records per day to...
Converting minutes to hh:mm:ss
I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...
Interpreting Index Usage Stats on an Availability Group
I've been querying sys.dm_db_index_usage_stats on the nodes of an availability group, and I've noticed...
Ask SSC