It's necessary because an incident may involve zero or more pedestrians.

Probably this is the best that i can do with visio for cardinality.

Here is the latest version of my db. I've attached also a possible (partial) extension of it.

Please feel free to give feedback.

Yes, i omitted the foreign key field in the existing table. relationship are all shown (except the two i was talking about in the previous post).

As soon as possible i...

The Person table have a IncidentId foreign Key (foreign keys are not shown in the diagram).

The IncidentFactor table in the diagram is wrong, its fields are IncidentFactorID (PK), ContributingFactorId (FK)

I'm...

Thanks.

Ok now it works.

I setup the sql agent access method on "This account" using the same account used to access the remote folder and the job works giving this account...

i changed the sql server agent log on "this account". but nothing changed.

Which account do i have to specify in this context? any of the local machine (server) ?

I...

Hi, thanks for your posts.

First of all i deleted my linked server and executed these lines of code to add another one :

EXEC sp_addlinkedserver

@server = N'provaPatenti',

@provider...