Hi,

I want to copy the table structures to a file of all the tables that are there in my SQL Server database.

How can i do thast???

Thanks and regards

Sagar

Open Enterprise Manager.
Drill down to the desired database.
Drill down to tables.
On the right side of the screen where all the tables are, right click the mouse.
Select "ALL TASKS"
Select "Generate SQL Script..."
Follow your nose from there...

--Jeff Moden

thaks a lot !!!

could you also tell me that what are the possible causes that mark a database in sql server as suspect mode and how to recover it.

thanks again

cheers

That would be in Books Online (comes with SQL Server) under "suspect database". Way too long to post here. Read everything before you even think of starting the recovery.

--Jeff Moden