| Author |
Coco's question of the Week #13
|
|
| cocolocopolo 2002-10-13, 3:33 am |
| RE: Linked Servers
Linked Servers uses four-part naming convention. But I saw this code:
Exec sp_addlinkedserver 'OtherServer', N'SQL Server'
Go
And also from somewhere I saw bracket [ ] notation.
What's going on ??? | |
| 2lazybutsmart 2002-10-16, 2:03 pm |
| wait a sec... what u saw and what is really there could be different. what do you mean by linked servers use four-part naming conventions?
cheers,
2LbS | |
| cocolocopolo 2002-10-17, 2:15 am |
| I saw four-part convention like this:
server_name.database_name.owner.object_name
or
linked_server_name.catalog.schema.object_name
whichever. |
|
|
|