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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 No Table Found

Author  Topic 

ian.caro
Starting Member

9 Posts

Posted - 2009-04-15 : 02:40:32
Hi,

Good day!

I am having problems with one of our database. We cannot view the table in the SQL. When we are clicking on the + sign of the database name it doesn't show anything. and we got an error message of "This database does not haveone or more of the support objects required to use database diagramming. Do you wish to create them?" when we click on yes nothing happens.

Regards,
IAN

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-15 : 03:03:41
Perhaps you are working on a SQL Server 2000 database?
Then you need to install the Compatibility Pack to see diagrams for SQL Server 2000 databases with SSMS 2005.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

ian.caro
Starting Member

9 Posts

Posted - 2009-04-21 : 05:55:23
Hi Peso,

Thanks for replying. we are using SQL2005 server.
Go to Top of Page

svicky9
Posting Yak Master

232 Posts

Posted - 2009-04-21 : 06:45:28
After you click yes repeat the same process it should work

http://msdn.microsoft.com/en-us/library/aa337513.aspx
http://www.sqlserver007.com
Go to Top of Page
   

- Advertisement -