restoring single table

Hi All,
I am taking transaction log backup every six hours. Now i want to restore just one particular table before 2 hrs of now.
How can i go about pls help me as its very urgent.
TIA
RegardsRESTORE

bcp out|||hi thanks for the reply

Can u be more specific as i am very new to this database

TIA
Regards|||You can restore the database to a second instance of the database and then DTS or use BCP to send the table over to your live database. If you are new I would reccomend using the DTS import/export wizard (remember to delete destination rows).

The other way is you could buy a third party tool called lumigent log explorer that would allow you to do this without restoring.

HTH

restoring database while database in use

Pls tell me, can we restore database when database in use,if so how?no.

ALTER DATABASE <BDNAME> SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE|||Can you change a trie on a car when it's moving?|||Um, doesn't 2005 has some ability to restore while in use? I don't have the documentation in front of me...|||Online restores are available in SQL 2005, but,,,,,

1) Only when you are running Enterprise Edition.
2) Only in the case that you are restoring a single page, or a non-primary filegroup.
3) You have all transaction logs up to and including the present online transaction log.
4) You set the database to read-only for the duration of the restore.