Delete All Tables from MS Access Database

HI

I want to delete all tables from an MS Access database.

i cannot use the designer . i have to do it thru an sql statement

a bunch of statements will also do . .

any body has a solution ?

P.s: All replies will be appreacited

Hi,

this is the SQL Server forum, perhaps you might try a Access forum, which might give you a wider variety of answers and experiences.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.desql

degree of parallelism in sql server 2000

Hi,

I would like to know how can I see the degree of
parallelism for select,insert,delete statements. I am on
SQL 2000 , I check SQL profiler , Performance event
class , It has got 1,2,3,4 degree of parallelism to
monitor degree but it says (7.0 delete, insert, select,
update)

what is the way to monitor Degree of Parallelism for SQL
server 2000. like to see if query is running in Parallel or not .

Please let me know.

Thanks,
Sac.YOu can use PROFILER to monitor degree of parallelism. For information refer to SQL Performance (http://www.sql-server-performance.com) website for articles and tips.