SQL Server database showing "Recovery In" mode.

If your database is in recovery mode, run a command similar to the following to bring it online(replace AdventureWorks with the name of your database):

  RESTORE DATABASE AdventureWorks WITH RECOVERY

Check out the previous post :

SQL SERVER Alter table statement with Examples

How to use different Facebook Plugins in Asp Net Page