"Lara" <lara***@gmail.com> wrote in message news:%23Pp%23vE$9FHA.3952@TK2MSFTNGP09.phx.gbl...
> Hi,
> My appln runs on a remote server. A few minutes ago i accidently ran a 'Truncate table' command.
> Is there anyway to recover it thru Query Analyzer. The DB Recovery model is SIMPLE and i have the
> dbOwner permission.
>
> Thanking in Advance
> Lara
>
>

"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:uqaa3U$9FHA.1996@TK2MSFTNGP10.phx.gbl...
> No. Restore from the latest database backup or re-load the data. You can
> try any of the log reading tools (I've listed some on my links page), but
> the data is most probably not in the log anymore because of simple
> recovery mode.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Lara" <lara***@gmail.com> wrote in message
> news:%23Pp%23vE$9FHA.3952@TK2MSFTNGP09.phx.gbl...
>> Hi,
>> My appln runs on a remote server. A few minutes ago i accidently ran a
>> 'Truncate table' command. Is there anyway to recover it thru Query
>> Analyzer. The DB Recovery model is SIMPLE and i have the dbOwner
>> permission.
>>
>> Thanking in Advance
>> Lara
>>
>>
>