An improved script to print all stored procedures of database, now with schema names. Jerry Hung’s cursor uses sys.all_objects and sp_HelpText.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Keeping Personal Data Out of Test Databases
Keeping personal data out of test databases requires synthetic records or masking during refresh, plus verification before access.
SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database
A simple cursor with sp_HelpText can print all stored procedures of your database. Switch results to text view with CTRL+T to read them easily.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
MVP Open Day 2008 in Goa: the group photograph shared by Allen Bailochan Tuladhar and memories of meeting friends in the MVP community. Read the original account and follow the rest of the Goa event series.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 3
South Asia MVP Open Day 2008 in Goa, Day 3: the blogging workshop, Community Buzz presentations, a beach walk, and closing celebrations. Read the original account and follow the rest of the Goa event series.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 2
MVP Open Day 2008 in Goa, Day 2: technical sessions, Community Buzz, a river cruise, and photographs with fellow MVPs. Read the original account and follow the rest of the Goa event series.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 1
MVP Open Day 2008 in Goa, Day 1: the journey, Windows 7 demonstration, Goan-themed evening, and photographs from Hotel Kenilworth Resort. Read the original account and follow the rest of the Goa event series.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.