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 |
|
mike86
Starting Member
24 Posts |
 Posted - 2007-07-30 : 03:25:47
|
| Hi, guys. i tried to create a diagram for a database in SQL Server 2005. After creating the diagram, there were no relationships indicated among the data. Why did this happen? I've tried to create the diagrams on 2000 version with same database, it did list out all the relationships but why not 2005?M i K e |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-30 : 04:38:48
|
a bug, a feature? who knows  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-30 : 05:22:42
|
| i dont think so... any other solutions?M i K e |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-30 : 05:45:17
|
| i've just tried it in SSMS for AdventureWorks db and the relationships are added with no problem.Do you have the relationships defined in your 2005 db verion?try the AdventureWorks db and see if it works for you._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-30 : 22:56:09
|
| Does client have same sql2k5 sp as on server? |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-30 : 23:33:41
|
| hmmm.... I tried on the master database. It cant work. I read the online tutorials, the AdventureWorks db needs to be installed separately due to some security aspects. This is a really tedious job to do. >.<M i K e |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 04:35:21
|
| installing adwentureWorks is simple. just run the MSI and attach the db._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
SQL Server 2005 Database Diagram