Browse: Home / mssql

mssql

Searching in all tables and columns of a database

Searching in all tables and columns of a database

By Armand Niculescu on October 30, 2007

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 [...]

Posted in | Tagged , | 2 Responses

Search and Replace tool for MSSQL

Search and Replace tool for MSSQL

By Armand Niculescu on July 7, 2007

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 [...]

Posted in | Tagged , , , , | 7 Responses

Forgot or lost SQL Server “sa” password

Forgot or lost SQL Server “sa” password

By Armand Niculescu on October 18, 2006

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:

Posted in | Tagged , , | 4 Responses