The most common way to view the code of a stored procedure in SSMS is doing a right-click on the stored procedure and select Script Stored Procedure as and select CREATE To. But this is not practical when you have several stored procedures to look at. Another way to do it by using a script: You might want to set the Results to Text for easy copy and paste for further editing. Further Reading How to view the stored procedure code in SQL Server Management Studio How to Find a … [Continue reading]
This is just quick tip found from this link and is actually good to use as a starting point: Further Reading How to Find All References to an Object in a SQL Server Database How to Search for a String in All Tables in a Database How to … [Continue reading]
The typical situation is you've connected to a network share with a User ID and a password. Then for one reason or another, the password was changed. As soon as you get asked to enter the User ID and password again, even after entering the latest … [Continue reading]
In the ever-evolving world of business, organizations are constantly seeking ways to optimize their processes, improve productivity, and enhance operational efficiency. One solution that has gained significant prominence is ESP Work Automation. ESP … [Continue reading]
If you want to look where a string is in all tables in a database, how do you do that? Here's a very helpful SQL to run: Further Reading How to Get Names of All Tables in SQL Server How to Find a Column Name in SQL Server … [Continue reading]