February 2007 - Posts

0
Comments

River Ang Bao Photo Album by darenhan

http://s20.photobucket.com/albums/b246/darenhan/river%20ang%20bao/ My shots with k750i handphone camera. :) Happy Chinese New Year to everyone!
0
Comments

Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space by darenhan

I was using sqlcache dependency in my dot net project file yesterday...and today somehow I cannot connect to my local database. Msg 945, Level 14, State 2, Server ServerName, Line 1 Database 'msdb' cannot be opened due to inaccessible files or...
0
Comments

Unable to enable SQL Cache dependency for tables with schema. by darenhan

I got this error below when trying to enable sql cache dependency for tables with schema. An error has happened. Details of the exception: Cannot create trigger 'dbo.Affiliate.Country_AspNet_SqlCacheNotification_Trigger ' as its schema is different...
0
Comments

Backup maintainence plan in SQL server 2005 by darenhan

I did the above maintainence plan to backup one of my db file but when i want to delete the rest of old backup files, it didn't work. This is because the file extension of the below screenshot should be "bak" not ".bak". Another...
Copyright SgDotNet 2004-2008
Powered by Community Server (Commercial Edition), by Telligent Systems