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