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 … [Read more...]
How to Find a String in SQL Server Stored Procedures
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 find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger How to Find a Column Name in SQL Server Database How to Get … [Read more...]
How to Remove Cached Credentials without Rebooting Windows
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 password, you're still getting an error message: Open Folder \\server_name\c$ is not accessible. You might not have permission to use this … [Read more...]
How to Search for a String in All Tables in a Database
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 Database Search all tables, all columns for a specific value SQL Server How to Find a String in SQL Server Stored Procedures … [Read more...]
How to Install Cryptomator on macOS
Cryptomator is a free and open-source client-side encryption tool that can be used to encrypt files before uploading them to cloud storage services. Here are the steps to install Cryptomator: Go to the Cryptomator website. Before you install the Cryptomator program, you can install macFUSE. Please note that Cryptomator recommended macFuse for Intel and FUSE-T for Apple Silicon but I … [Read more...]
- 1
- 2
- 3
- …
- 32
- Next Page »