ok Sorry For That But I get Into This Error About 8 hour And I am Now Behind Schedule.Again Sorry For That

I Just Download Model From This Site And It Work.HAAAAAAAAA

http://www.kodyaz.com/sql-server-tools/model-database-error.aspx

when I write SQLSERVR.EXE -c -T3608 for Recovering Model DB IT says :login Fail For nt Authority Network Service.What Can I Do????????????

my question is as you say in example.it is better EmployeeID and DepartmentID be both primary key as they are foreign key or i unique them to prevent duplicate info???

Koen Verbeeck (10/23/2013)

---

In your table structure for Line you gave in your original post you specified LineID,PointA,PointB.

I don't see any RampID or PreRampID.

Please read the first link in my signature...

tables(Ramp and PreRamp)have one(Line Table) to many(Ramp and PreRamp Table) relationship with Line Table and i dont Know how can i do that.because there is RampID and PreRampID which one...

how can i create a table that have two foreign key.i mean my Line Table have relationship with two table(Ramp and PreRamp).this is the point that i get confused!!!

i mean how can i create stone table in ERD?????

plz sm help

ok. i change query this way and it is work.is it optimize query??

select

BsH.SabtHazineId,

BsH.HazineID,

BsH.EndUserNAme,

BsH.Tedad,

BsH.sabtHazineDate,

BsH.Describtion,

Coalesce( BH.HazineName, H.HazineName ) as [HazineName],

...

i write this query but it give me this error:

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

select...

for example when i want to show list of books to admin.I want to show who insert and edit each record of it and when it happen.it takes query executing...

i have deleted Info From a table thay have foreign Key in AgencyDB and It Move To AgencyBackupDB.this my problem:

how can i understand That Info that Move to AgencyBackupDB when...

in my AgencyBackupDB there is no Constraint and when I delete Info From SabtHazine table In AgnecyDB. how can i Delete This Info that I face with No problem For...

plz sm help