how to get all database schema?

[champ]

hello,

here is my problem.
I have to rebuild database after crash. there is no backup. So
I did a bcp to get data from. But I do not have the original database so my question is how to get the full schema off the data base, tables,colomns,stored procedures etc...

thanks lot for any help.

[rmiao]

Do you still have .mdf and .ldf files? If so, you can attach them. If not, nothing you can do unless you scripted db before and saved the script somewhere.