Monday, October 22, 2012

My PC is slow when I try to shut down


Check your EventViewer and localize the error. This can depends on something is wrong with Windows Update and need to be reparated.

Go to
http://fixitcenter.support.microsoft.com/Portal
and download their tool and run it to fix all possible problems.

Tuesday, October 2, 2012

AssemblyInfo.cs' could not be opened ('Unspecified error ')


Error AssemblyInfo.cs could not be opened



So you open a project in Visual Studio 2010 and get an odd error:
AssemblyInfo.cs' could not be opened ('Unspecified error ')
What this means is that the AssemblyInfo.cs file is either missing from the Properties folder in the project or there is a permissions issue. If permissions, update the ACL (File > Properties > Security), close and re-open the project. If missing altogether, you just need to recreate it using the following steps:
  1. Within Visual Studio 2010, select Tools > Create GUID
  2. Click Copy (or New GUID then Copy)
  3. Click Exit
  4. Expand the Properties folder in the Solution Explorer (Control + W, S to open)
  5. Delete the AssemblyInfo.cs file shown with the exclaimation point
  6. Double click on the Properties folder - this should open the Properties window
  7. On the Application Tab, click the Application Information... button
  8. Fill in the application information, paste the GUID you copied into the GUID field - when done click OK

Monday, October 1, 2012

The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)

When you try to rename a database, you get the following error message:

Problem:
The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)

This can be resolved by the following:

sp_who

Check which Process id use your database (dbname) and kill the process:

kill 15

Where spid = 15 is the process that lock the database you are trying to have a lock on.