No cacho ni una guea esta caga de arti culo

Anonymous User 11/8/2004 8:09:04 AM

Just one question: how can I access e.g. Excel or txt files on remote machines?

Anonymous User 10/29/2004 5:44:20 AM

I don't believe that the following line from the article is correct 'Until NT 5.0 ships, this approach is the only option available if your users are connecting through integrated security. ' It should rather read 'Until NT 5.0 ships, this approach is the only option available if your users are connecting through SQLServer authentication'. Otherwise the writer is contradicting themself in the paragraph below. Using sp_addlinkedsrvlogin with @useself set to TRUE is only valid for SQLServer authentication unless the O/S is Win2000.
Further sp_addsrylogin should read sp_addlinkedsrvlogin. The writer should not be addressing 7.0 security as Integrated security. This is a 6.5 feature and they should be discussing in terms of the authentication model.
Also, the writer discusses three security options but essentially the first and the third paragraphs are discussing the same ie impersonation.

Paul Williams11/23/2001 7:30:28 AM

Good article .... I have one question ... Does the openrowset execute the stored procedures addlinkedserver, addlinkedsrvlogin, etc ... I need to insert into sql 7 tables from access and the access mdb files will change.
I have written a stored procedure that reads a list of tables and can change the linked server info thru the sp_xxx
only when the mdb file changes. If I use openrowset and the stored procs are executing behind the scenes then they will run every time which isn't necessary. Any thoughts would be appreciated.
Thanks Joe

Joe Finnerty 5/17/2001 6:24:56 AM