Searching in all tables and columns of a database
I was forced recently to do some maintenance and bug fixing on an aging .NET-based CMS. Most of the problems were in the SQL Server database, with lots of corrupted entries. The most frustrating thing however was that at times I didn’t even know where to find the entries. Try finding some specific strings in [...]
Full Story
Search and Replace tool for MSSQL
Every now and then I come across some bad practices that needs repairing. This time the “no-no” was in a database tables. I had to change hard-coded links in quite a few tables. Replacing 10,000 absolute URLs spread across the database can be a huge headache, so I decided to work smart, not hard. So [...]
Full Story
Forgot or lost SQL Server “sa” password
Here’s a neat thing to remember if you’re using MSSQL: To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:
Full Story