linked vs remote

What are the differences between Remote Server and Linked Server
anyone have a good reference page ?Remote server was introduced in the first Windows NT version of SQL Server (version 4.2) and allowed
for execution of a stored procedure on another instance:
EXEC srv.db.owner.proc
Linked server is a more modern concept, and allow for referencing tables on another instance:
SELECT ...
FROM srv.db.owner.tblname
...
Sometimes the term Linked Server is used as a superset of Remote Server (including both above),
sometimes the terms are used in a more specific manner.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tony B." <Test@.spam.ca> wrote in message news:uHZgjtEzGHA.4408@.TK2MSFTNGP05.phx.gbl...
> What are the differences between Remote Server and Linked Server
> anyone have a good reference page ?
>

linked vs remote

What are the differences between Remote Server and Linked Server
anyone have a good reference page ?Remote server was introduced in the first Windows NT version of SQL Server (
version 4.2) and allowed
for execution of a stored procedure on another instance:
EXEC srv.db.owner.proc
Linked server is a more modern concept, and allow for referencing tables on
another instance:
SELECT ...
FROM srv.db.owner.tblname
...
Sometimes the term Linked Server is used as a superset of Remote Server (inc
luding both above),
sometimes the terms are used in a more specific manner.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tony B." <Test@.spam.ca> wrote in message news:uHZgjtEzGHA.4408@.TK2MSFTNGP05.phx.gbl...[vbco
l=seagreen]
> What are the differences between Remote Server and Linked Server
> anyone have a good reference page ?
>[/vbcol]

server, Excel - Permissions Issue

Hello,
Linked Server to Excel spreadsheet
I have no problem executing a Linked Server query through Query Analyzer
(Administror) or through an ASP page connecting through a Login setup throug
h
Enterprise Manager with: Server Role - Systems Administrator. However any
ohter lesser Login / Role yields:
ERROR -
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'
NOTES:
* Link Server Properties / Security is - DEFAULT
* Permissions on Excel spreadsheet & directory are - Everyone
Thus, I believe what I'm looking for are the What and How on setting
permissons for executing this query on the linked server?
I have been struggling with this for several days and do not find much on
the web per this issue... any help would be appreciated.
Thanks, j"JLatiolait" <JLatiolait@.discussions.microsoft.com> wrote in message
news:1F47F9C9-18EF-4B60-9D36-42BBD1C56052@.microsoft.com...

> Linked Server to Excel spreadsheet
> I have no problem executing a Linked Server query through Query Analyzer
> (Administror) or through an ASP page connecting through a Login setup
through
> Enterprise Manager with: Server Role - Systems Administrator. However any
> ohter lesser Login / Role yields:
> ERROR -
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'
> NOTES:
> * Link Server Properties / Security is - DEFAULT
> * Permissions on Excel spreadsheet & directory are - Everyone
Everyone = what permissions at the NTFS layer?
Steve