.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

database diagram question

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server
in sql server 2010, is it possible to create a database diagram where there are two tables connected showing a many-to-many relationship without a bridge table?

View Complete Post

More Related Resource Links

database interface design question


For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?

Thanks for any feedback.

Database CurrentUser Question

I am trying to check whether the user connected to a database is db_ownder so I am using the IsDbOwner property on the database object that was created from the Server object but it is setting the UserName to guest as opposed to the user connecting - any ideas? Thanks Scott

Detach/Attach database question

I recently restored a database from SQL7 to SQL2005.  When restoring the database I needed to create a c:\data\data folder or else it would not restore the mdf and ldf files. I would like to move these files to a new location.  Copied the the two files to a new folder, C:\database.  Using the sql studio manager, preformed a task to detach the database, then attach the database with the new location. This seemed to work, I am able to access my application that uses this database.  However, any changes I make to the program, are not writing changes back to the mdf file.  When I open the program, these changes are still in place, but the mdf file should be updated, correct?  When the database files were stored in the c:\data\data folder, any little change I made to the program changed the modified time for the mdf file. Is there something missing or where could these changes be written to?

Database diagram support objects cannot be installed...

I can't make a diagram on our server(Win2003 x64,SQL 2005 Enterprise x64 sp2 3054). I have tried to login as an admin and create a new db, but get the same message - 'Database diagram support objects cannot be installed because this database does not have a valid owner. To..' Also tried to make a diagram from the ReportServer db.   Any suggestions?

Database diagram

Hello all, We have been assigned a project for future developement. The problem is original developer did not create any data model, so we are in trouble understanding how db structure flow goes. I know we can create database diagram (even did that), but db contains 162 tables so the db diagram becomes so big that it does not fit in the monitor's view. Viewing each table > keys (for relationships) is not possible. Any suggestions, to make the things simpler.

Database diagram failur - Invalid class string SSMS 2008

Hi There -  Help needed In SSMS 2008 (not express) the Database Diagram  cast the exeption "Invalid Class String" (MS Visual Database Tools). Why is this happening. I have used the diagram designer before succesfully My OS W7 - SqlServer 2008 - every thing updated  - every service pack installed I have tryed reinstall seceral times - not positiv What is going on - It had been working (1 month ago) Please help Freddy

Sharepoint Database size question

We have just installed Sharepoint 2010 in our network.  We currently have 2 users who are accessing the system, since we are in alpha stage.  What I have noticed is that  User Profile Service Application_SyncDB database size is at 800mb.  is this normal? In addtion, WSS_Logging database size is at 140mb. 

Question on Distribution Database ** HELP ! **

Hi, I am new to SQL2K8 replication.  I have been reading lots of articles/tutorials on this subject.  I was able to setup a Transactional Replication.  Everything is working as expected.   However, I wanted to further investigate as to what events are taking place behind the scene just to educate myself a bit more.  I found that in the process of creating my transactional replication, it created the "Distribution" database under the "System Database" node on my SQL 2008 box.  There is only one table called "UIProperties" with a column called ID.  My question is where is the Log Reader keeping the changes in my publications.  I can see when I made a change to a row in my publication, it got replicated to the subscription database.  But where is SQL Server storing these changes??  I guess when the distribution agents runs, where does it get the changes from?  From my reading, the Distribution database is supposed to keep tracking of these changes.  But I am finding any changes I made to my publication.  Can someone educate me on this? Thank you.  

about date in database question

hi i need to find data between 2 date's and time's. i use one field for date ,  and one field for time. **is it be better to use only one field for date & time ?** i see that it came in  `dd/mm/yyyy hh:mm:ss`  format that  can contain date and time. this question is for acceess and for sql-server thank's in advance

Newbie question about adventureworks database


Hi Guys,

I downloaded the Adventurworks2008 database and the AdventureworksDW2008 database for practice with SSIS.  I was wondering what the difference between the two databases is, because in the exercises im following it is stating that i will need to extract data from  the Adventureworks2008 database to the AdventureworksDW2008 database.

Is the the AdventureworksDW2008 an empty database and we are just extracting OLTP data to it? Please any help in clarifying this will be highly appreciated. Thanks!

Worker & Location Database design question


Hello to forums :)


I have a simple question on design.

A company has several 'Worklocations'. Each location employs several workers. Every worker can be associated with multiple locations.

So, I have decided to create below tables. please letme know if there is a better way to design it

worker table
wid (primary)

location table
lid (primary)

workerlocations (WID+LID => primary key)

Is this sounds right for you guys? let me know

error getting database diagram on sql server 2008


Database diagram support object cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the database properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, the add the database diagram support objects.

i do have a valid owner in the database Files tab.


any idea ?

Question about SQL Server Database sizes


I have SQL Server 2008, when I go into Server Management Studio and I right click on my database and choose properities.  I see two things, I see Size of 200.13 MB and Space Available of .44MB.  Does this mean my database can only grow by .44MB more of data?  If so, is there a way to change the max size?  When I was looking at documents on SQL Server Express 2008, I saw a 10GB limit on each Database instance, so I was assuming SQL Server 2008 would provide me more than 200.5 MB? 

I'd really appreciate any info/clearing up for me.



Can anyone answer of my Question regarding SQL server database connectivity??

I want to connect my sql server database using my desktop application. Now Just tell me can i connect directly to my database using IP Adress in my connection string????? my database

Exist is in other country


Please clear this confusion.


Thank in advance


SQL Server 2008 (Std) : Database diagram distorted on printout



When I create a diagram in MS SQL Management Studio 2008 Std (version see below) I have an ugly mis-rendering on every table on the printout. I have SP2 applied on the client (Managment Studio) and on the server. It looks like "a part of a window" is drawn below each table.

I did:

1. Create new diagram
2. Add Table
3. print diagram to pdf printer or real laser printer

=> same result ugly printout with portion of a window under the table.

I went and used  MS SQL Management Studio 2008 R2. And it worked (from another PC). Directly on the server using SQL 2008 Managment tools it produced the same distorted output.

This is annoying. What am I doing wrong?
Any tips are welcome

Best regards



Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3615
Operating System 5.1.2600

database id question




Running this on an SQL 2005 server


This tsql statement returns 6

select DB_ID('erm') 

Also, this tsql statement returns 6

select database_id from sys.databases where name = 'erm'

But this one returns 5 rows all with a&n

Database Diagram functionallity


I posted a question before about 2 tables one with a foreign key being that the primary key from the first table. it was student and status

student table has id as primary key incremental identity and status has id as a foreign key from student.

I created the relationship in the diagram between the 2 tables. And I found out that when you create a new student the id is not populated automatically into the status table.

My question is then:

why do we want to create that relationship or others in the diagram? if it is not going to be automatically populated, I needed a trigger to do it.

thanks :)

Mauricio Quiroga www.ildw.com
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend