Thanks, eventually found what i needed to do. I needed to create the table in this format:

CREATE TABLE dbo.tablename( columnname1 smallint identity(7,2), columnname2 char(20) )

Am using the go statement after each create table statement do you think that is the problem.

Thanks very much for this it was really helpful, do you have any idea how i can show the relationship, in terms of one to many and many to many?

I am using Visio to design a new database with an existing schema,and am using SQL server version 9.0.1406.

Am also using visio 2007, which is the professional one.

Can you kindly let me kniow which one you are using?

MS Visio

Can I use PK in brackets beside the column name that needs to have a primary key?

I used the following script to create the table for the results to be inputed into the space_used table, but doesnt to work as i get the following...

even if i use the sp_spaceused, how will i populate hem into a table that i created?

I finally got it fixed - just repaired the .Net framework from the control panel, funny enough i guess.

Have you created the virtual directory with the report cnfiguration manger? (thats if your using SQl2K5)

wow.......i just want thank you all for the coaching,it has been really helpful.:)

Hello Ramesh

That was what i was trying to do, for quite some time, can you kindly explain to me how you created that query, as I can see that you...

having difficulty trying to retrieve the rest of the details, am using :

SELECT books.*

FROM books

INNER JOIN ordered_items

ON books.bk_no = ordered_items.bk_no

GROUP BY books.bk_no

HAVING COUNT(ordered_items.bk_no)>2

and getting the error message:

Msg 8120, Level 16,...

Thanks, used:

SELECT books.bk_no

FROM books

INNER JOIN ordered_items

ON books.bk_no = ordered_items.bk_no

GROUP BY books.bk_no

HAVING COUNT(ordered_items.bk_no)>2

Thanks once again now able to understand the theories of JOIN