Category Archives: SQL Server 2000

Here’s and example that i want to show you to change digits number into text. This Function belongs to madhi, he make this function to create report with many pages and it can’t be done by creating parameter in reporting … Continue reading →

This time i’d like to share about how to backup and restore database while user still online or something that client still active. Usually even client already close his application but in SQL Server 2000 still show that client connected … Continue reading →

On part 1, explain the Simple way to shrink Transaction Log in SQL Server 2000 with some short explanation. This time on part 2 , i will explain this and what’s inside the Option on part 1. Recovery Model SQL … Continue reading →

Perhaps this trick was an old trick, but i’ve just do this after several years i use SQL Server 2000. It’s begin when my database transaction grows until 2GB. When i try to backup and bring it to my PC, … Continue reading →