DROP all stored procedures
This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.
2009-03-13 (first published: 2009-02-12)
1,024 reads
This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.
2009-03-13 (first published: 2009-02-12)
1,024 reads
Search for a text in all the stored Procedures in a Database
2013-01-04 (first published: 2009-01-14)
3,620 reads
2010-09-10 (first published: 2008-11-17)
32,970 reads
2008-10-23
1,433 reads
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
2010-08-13 (first published: 2008-08-13)
61,033 reads
2008-07-17
345 reads
When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.
2008-05-28
8,598 reads
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
32,963 reads
Building an application with modular programming not only speeds development, but can make for a more stable application. New author Sreeju Jumar brings us a look at how you can further modularize your stored procedures.
2008-04-29
11,921 reads
Different ways of passing sets of data between stored procedures.
2008-04-08
7,906 reads
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...
By Rob Sewell
"Let me know where you get your magic pixie dust from!"
By Steve Jones
flashover – n. the moment a conversation becomes alive and real, when a spark...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Hi Everyone, I have the data in the below form : Desired output: Here...
What was the originally name of the appliance that eventually became Azure Synapse Analyics?
See possible answers