Is it possible to recover a dropped table?

Hi All, Accidentally I have dropped a table and that is the main table for my application. I dont have a backup of it. Is there any way to recover it.Please help me guys. Thanks, Kumar.

When a database is created in SQL Server, it is set to Full Back Up by default. So, your table should be available by restoring the transaction backup. Try going to the "restore database" options by right clicking on the database name in Enterprise Manager and selecting All Tasks.

on my foot once, and I don't think I ever recovered. Lots of luck.

I thought it only held the transactions, not the whole database schema. That's what backups are for. In other words, in the Full Recovery model, SQL server writes every update, delete etc. but it doesn't actually save a copy of some table or table schema script from which you could restore a dropped table. I suppose its possible to manually recreate a table that was dropped by examining the log transactions, but its sure not something I'd want to have to do.

   FLASHBACK TABLE table_name TO BEFOR DROP;