The new fix is ready.

I would look at the runas command, I can't figure out how to give it a password programaticaly maybe you will have more luck.

Note: I have not needed to ever...

It the server setup to use TCP/IP connections?

What port is it using?

Is there a firewall? If so, is the above port open?

Can you connect locally using the below as server...

If you run the below command does it report the correct user?

SELECT SYSTEM_USER;

Tim S

Right Click on the short-cut to QA and choose Ran AS then pick or enter your username.

Tim S

I am thinking today or tommorrow.

They took down the KB article.

http://support.microsoft.com/kb/904660/

So, I think they must be updating it.

Tim S

Have you checked to see if someone changed the code in the master stored procedure sp_MSdbuseraccess.

It is what displays the list of DBs

Try the following in Query Analyzer

use master;

GO

EXEC sp_MSdbuseraccess...

Number one is NOT true if the table and views reside in different databases and

DB chaining is turned off.

( I don't use DB chaining so I don't know what it...

Please do this ONLY after you grant your NT account sysadmin rights.

exec sp_denylogin @loginame=[Builtin\Administrators] --> this stops any Administrator, including Domain Admins

Tim S

Did you check "Cross database ownership"

Like be low code replace Northwind with the database with the tables in it.

Tim S

USE master

EXEC sp_configure 'Cross DB Ownership Chaining'

EXEC sp_dboption 'Northwind', 'db chaining'

If you want to try putting the same drivers just install MDAC 2.8 SP1

http://support.microsoft.com/kb/899456

AS-IS No Warrenty

Tim S

Download link: http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en

Have you tried using cliconfg.exe to create an alias that uses the fully quailfied domain name in the server name?

It could be a WINS name resultion that is causing...

It is very hard to convert a well written trigger to use a stored procedure.

Most likely your trigger will not work on multiple row update very well.

Edit: Even if you...

http://support.microsoft.com/lifecycle/?LN=en-us&x=15&y=14&p1=2852

Tim S

quick & dirty answer below

note: I don't use cursor very often and the datatypes are most likely not the best.

Tim S

declare @server_name varchar(256), @server_id int, @rmtloginame varchar(256), @loginame varchar(256)

DECLARE linked_servers...