Monthly Archives: June 2011

Exclusive access could not be obtained because the database is in use

You may come across an error as shown below while backup/restoring a database using SQL Server Management Studio 2005. Restore failed for ‘servername’ (Microsoft.SqlServer.Smo) Additional information: System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.Smo) … Continue reading

Posted in SQL Server | 1 Comment

C# – Using JavaScriptSerializer to convert objects to JSON

I was working with Ajax and came across a situation where server response was required in JSON format. OK there are ways to manually create such a response but the code will look crap, coupled and re-usability of the code … Continue reading

Posted in .NET C# | 2 Comments

JQuery – How to hide your email from harvesting tools

It may sound a bit strange to few of the folks out there but it makes complete¬† sense. Some of you wonder where the hell these spammers get your email address from and bombard hundreds of email everyday, making your … Continue reading

Posted in JavaScript, JQuery | Leave a comment

cannot be reused until after the next BACKUP LOG operation.

When trying to create a full text index on a database you may get the following error message: “File ‘index’ cannot be reused until after the next BACKUP LOG operation” Solution (SQL Server 2005): 1) Right click the database and … Continue reading

Posted in SQL Server | Leave a comment

Limit Large Attachment Downloads in Outlook 2003-2007

There are few people out there wondering how to limit the file attachment size for download due to the following reasons: You don’t want to download large attachments on your mobile (limited data availability) You have set up multiple accounts … Continue reading

Posted in Microsoft Outlook, Uncategorized | Leave a comment