Database is in use error while restore database from backup (SQL Server)

Sometimes you are trying to restore a sql server database and you'll get the error: "Exclusive access could not be obtained because the database is in use." The Solution is type the script below and run it (SQL Query) : Before Restore Attempt use master alter database DB_NAME set offline with rollback immediate; After Restore use master alter database DB_NAME set online with rollback immediate; ...

Lanjut Well

Error HRESULT E_FAIL has been returned from a call to a COM component (SQL Server)

When loading large files – over 100MB with  Sql Server Management Studio 2008 you might get the following error: Error HRESULT E_FAIL has been returned from a call to a COM component. The Solution is run CMD (Run As Administrator) then type the script below : sqlcmd -S [server] -U [username] -P [password] -i [path file of sql script] Example : sqlcmd -S .\MYSQLSERVER -U sa -P pass -i C:\Database\newscript.sql ...

Lanjut Well

HTTP Error 404.3 - Not Found in IIS 7.5

Error : HTTP Error 404.3 - Not Found The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map. Screenshot of the error page This is a common issue and happens when IIS is installed after VS or .NET framework. So you must use aspnet_regiis.exe to register version of .NET framework you are using. The Solution is run CMD (Run...

Lanjut Well

Hide Disable CommandField ButtonField In GridView Asp.Net

In this example i'm going to explain how to Conditionally Hide Or Disable GridView CommandField Or ButtonField Programmatically In Asp.Net Using C# And VB. Conditionally Hide or disable Gridview commandfield buttonfield in asp.net. I'll use field such as Select,ShowEditButton and controls in TemplateField for this demo. Northwind Databse is used to populate GridView. Enable selection from smart tag in design mode to show SelectButton Hyperlink...

Lanjut Well

Well Exchage Link (Tukeran Link)

Sobat Well Blog yang ingin tukeran link, bisa lho.. Langkah-langkah tukeran link di Well Blog : Silahkan copy script dibawah ini dan taruh di blog atau web kalian <a href="http://wellysundawa.blogspot.com" title="Welly Sundawa Well Blog"> <img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKU1RH5H3o_aQQwwQ16KEv-GJ8dmVmNz7wyykoHmZSvMVj5EkzdKUIk3QM96GDpHVf1Pqbve-qsWqTR6ewr1zvLZfBTAzivUdNEAfPe1XFhAYKwj6SuxOhUugJxhPXJtZYR9Jg8urjk6I/s1600/stroke-white400x60.png"...

Lanjut Well

Visual Studio .NET Setup hangs on Generating setup script

Finally I found it... After couple of days trying to install Visual Studio .NET 2003 and having the same problem of hanging at 60% of the Generating Setup Script, this is what i did: 1. open your Window Task Manager (Ctrl-Alt-Del) 2. Select the Proccesses Tab 3. Sort by Image Name 4. When the installation starts a new task called "msiexec.exe" is created. 5. Select that task 6. When the setup reaches the part of "Generating Setup Script" and the...

Lanjut Well

Goodnight Electric Biography

(Goodnight Electric) Goodnight Electric adalah sebuah proyek musik yang dikerjakan oleh Henry Foundation (voice/programmer) pada akhir tahun 2003 di Jakarta. Sebuah konsep musik studio yang menggunakan perangkat lunak (software) komputer sebagai media dalam menciptakan berbagai suara dan ritme yang menjadi materi utama pada musik yang dihasilkan oleh Goodnight Electric. Bersama Bondi Goodboy (synthesizer/voice) dan oomleo (synthesizer/sequencer/voice),...

Lanjut Well