It comes back with an error... Do you want to see my full query?

Thanks!

hey my question is

the logic between ELSE and END

how do I write that out in TSQL ? or have I written it right?

Will do the next time Gail...

So how else do I do point in time recovery from transaction logs if looking at the timestamps for a dropped table or anything else...

Okay, I know this is a topic from a long time ago, but I'd rather search and reply than create a new topic from scratch. So now to my question..

I...

Great, Thanks! Will try it out..:D

Cool.. so then.. how can I pull of this same trick while having SQL Server 2000 as the backend DB ? I know sys.objects does not exist...but can't think of...

I'm running SSMS , SQL Server 2005. Was running this query on a DB which has a backend on SQL Server 2000. Could that be it?

When I run the query I get the following error:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'sys.all_objects'.

What could be the issue?

Thanks,

O