Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-09-01 : 08:41:22
|
| Data model can be done some tool like ERWIN etc... like that can it be done in MS SQL ?? . |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2008-09-02 : 00:15:17
|
| i think in sql 2000 enterprise manager can do.. but that is for created table,cannot create new am i correct?? .. can u say any document link to see how to do.. also if i create that will the script also generated ??? this diagram and scrpt will be stored in what kind of file ??? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2008-09-02 : 07:52:49
|
| yes tara i get u .. But where can i check ...just say where it is to do.. let me try ...or any link do u have ? |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-09-02 : 10:51:49
|
| In Enterprise Manager, select the database --> Diagrams --> click new. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-02 : 11:05:06
|
| cognos79, you can't use Enterprise Manager with SQL Server 2005.niranjankumark, you can create an ERD in Management Studio for SQL Server 2005. Just navigate to Database Diagrams under the intended database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-09-02 : 12:24:22
|
| I was saying in reference to sql server 2000. |
|
|
|
|
|
|
Data model in MSSQL