Restore deleted table

Is it possible to restore the deleted table? No changes were made to the
database after the table was deleted.
SQL Server 2000.
Thanks.You can restore the database to a new location/name and get at teh table
that way.
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||I just want to make Jay's answer clearer.
First of all, I hope you have a backup of your database. If so, restore your
backup using another name and then export mentioned table to your current
database. (Right click on your restored database and then go to Tasks and
Export...)
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||Try ApexSQL Log.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||Thanks for the replies.
Is there a free tool to work with a transaction log (at least to view it)?
Vik
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:13huna7gk3qcb3a@.corp.supernews.com...
> Try ApexSQL Log.
> --
> Kevin G. Boles
> TheSQLGuru
> Indicium Resources, Inc.
>
> "Vik" <viktorum@.==yahoo.com==> wrote in message
> news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
>> Is it possible to restore the deleted table? No changes were made to the
>> database after the table was deleted.
>> SQL Server 2000.
>> Thanks.
>>
>