Hi all,

i am still new in sql. i want to generate database in sql 2005 :

· Table Column Details
· Indexes
· Views
· Stored Procedures
· Functions
· Triggers
· Primary Keys
· Foreign Keys
· Default Constraints
· Identity Columns
. etc) to word.

could anybody help me with this one ?

thanks before

irvinia

welcome to the forums. start from here. http://msdn.microsoft.com/en-us/library/ms176061.aspx then whatever you need just search in books online or msdn like CREATE TABLE CREATE FUNCTION ...

First install sql server 2005 and go to book online...

You can down load sql server from http://msdn.microsoft.com/en-us/sqlserver/bb671254.aspx

search as previous poster mentioned...

If you mean creating documentation for database , in word file 

That is a starting:

• open SSMS 

• select database
•  right click, select tasks -> generate script
•  a wizard is displayed
•  go with wizard
  
  you will generate text file , which you can open by text editor or word  

Also, you can use Visio for reverse engineering database.