conventions about namereferences

Hallo,
Can someone tell me the difference between pcd_mn..nslAfdeling and
pcd_mn.dbo.nslAfdeling?
I know that in this case pcd_mn references the database on the server
and nslAfdeling a table in that database. I also know that dbo
references the owner of the database, but who is '..'?
Thnx in advance for replying
Groeten RonWell, if you dont specify the owner ('..' syntax) then SQL server first
assumes that you are the owner of the object (googleRon.nslAfdeling). If
that object doesnt exists it goes with the default 'dbo' owner and finds the
table under 'dbo.nslAfdeling'. So, the behaviour should be the same, but I
would recommend using table owner.
MC
"googleRon" <ronvdheijden@.gmail.com> wrote in message
news:1148374201.120687.276900@.j55g2000cwa.googlegroups.com...
> Hallo,
> Can someone tell me the difference between pcd_mn..nslAfdeling and
> pcd_mn.dbo.nslAfdeling?
> I know that in this case pcd_mn references the database on the server
> and nslAfdeling a table in that database. I also know that dbo
> references the owner of the database, but who is '..'?
> Thnx in advance for replying
> Groeten Ron
>|||Marko,
Thnx.
Ron