I don't think you can do this using SQL 2000. You will have to restore
the db first.

John

-----Original Message-----
From: aaron [mailto:[Email Address Removed]
Sent: Monday, July 28, 2003 11:20 AM
To: LazyDBA.com Discussion
Subject: Restore single tables from bak

How can I restore 1 or 2 tables from a .bak ?


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page