Relationer mellem to databaser

yes

hvordan!! det var lissom det der lå i spørgsmålet ;)
/chr

I am lookingfor a link so that you can see how its done, will get back!

oki... cool... thanks

Make a view in the one database which refers to another database

SELECT * FROM DatabaseName.dbo.TableName

Blander mig lige lidt! :-)

Men når jeg laver et view: CREATE VIEW opdater AS select * from <databasename>.dbo.kunder

og kører dette får jeg denne fejl:
Msg 916, Level 14, State 1
Server user id 175 is not a valid user in database \'<databasename>\'
Msg 208, Level 16, State 1
Invalid object name \'<databasename>.dbo.kunder\'.

Jeg har \"granted all\" i permissions, men får stadig ikke lov???

You need to grant permissions in both databases

I know and I did, but it does\'nt work anyway!?? Schould\'nt you login the other database?

Not as far as I know! In SQL the Logins is for all databases within the server, so you are logged in.
I use this quite often and it doesnt give any problems.

What version are you using? 6.5 or 7.0 could that be the problem?

7.0